Pop Ups To Be Proud Of

Hello,

Here’s a simple little QlikView trick which will make your Pop Ups really Pop Out and contain so much more information.

The example shows what you get by default in QlikView. Here I’ve created a combo chart which shows the average (line) and the Min / Max values are displayed in a bar with an offset, kind of like what you may see in Excel.

QlikView Pop Up Text

QlikView Pop Up Text

By hovering over the bar chart you can see its values (spread) but that’s not really the information you want. Really what you want to know is the Min and Max value. This can be done using a new QlikView expression and you’re not limited to the amount of information you can add into the pop up text box. This becomes really usful for this and other charts such as the Pie Chart. I tend not to use Pie Charts as I don’t think the information they give makes best use of the space they take up. That said by adding more information into the Pop Up text you can justify these charts more and more.

QlikView Pop Up

QlikView Pop Up

 

The technique.

  • First create your expressions in the normal way and deselect ‘Text as Pop Up’
  • Next create a new expression but deselect all display types such as Bar, Symbol, Line, etc (The image next to your expression should look like a speech bubble and Info Icon)
  • Add all the text you want to display into this new expressions definition for example “=’High: ‘ & sum(High)  & chr(10) &  ‘Low: ‘ & sum(Low)
  • Now check ‘Text as Pop Up’ for this expression

 

I’ve placed an example QlikView file here on the Qlik Community for you to see it in action.

I hope this is helpful, would love to hear your comments.

 

Thanks

Richard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s