topic Re: Multiple values in popup labels in QlikView

Multiple values in popup labels

Thu, 31 Oct 2013 14:03:58 GMT

Hi,

How can I limit the number of displayed values in popup labels? I created a continuous line chat with over 100,000 values on the X axis. I turned off "Pop-up Labels" in "Presentation" tab and also created an expression for the information displayed, but still fail to limit the list to a single value. I tried to use min or max but did not work.

Re: Multiple values in popup labels

Thu, 31 Oct 2013 17:27:35 GMT

Hi,

You can try left() function.

Rebeca

Re: Multiple values in popup labels

Fri, 01 Nov 2013 10:19:34 GMT

Hi,

Left() function helps me to limit the number of decimal places, but not the number of rows in pop-up label. It is true that reducing the number of decimal places is reducing and the number of rows displayed, but it is still greater than 1.

My goal is to display a single row in pop-ups. Instead of Left() function I used Num()

= 'Sellers: ' & Num((PR_Rank / vCountSellers) ,'#.##0,0%')

Re: Multiple values in popup labels

Clever_Anjos — Fri, 01 Nov 2013 11:07:43 GMT

Could you post your exact expression?

Re: Multiple values in popup labels

Anonymous — Fri, 01 Nov 2013 11:44:31 GMT

Looks like it is the nature of continuous combined with pop-up labels.

Re: Multiple values in popup labels

Fri, 01 Nov 2013 14:03:19 GMT

This is a little trick that might help you.

Untick pop-up labels in expressions for the expression you already have. Create a new expression in the charts expression tab with the text and expression you like, example =’The text’&sum([The number])

For the same expression you deselect line/bar/symbol as display option but instead select text as pop-up.

You basically create a separe expression that is not shown as a line/bar/symbol, but only as a pop-up.

Hope its helpful.

Re: Multiple values in popup labels

Fri, 04 Apr 2014 23:44:11 GMT

Slick trick!! I wish I knew this long before. Is that the only way to format the Pop-Up Tool Tip?