Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
shinnickr
Creator II
Creator II

Text as popup causing extra data points to appear

Hi there,

I am using the trick described here: Pop up Text with more information to have some additional pop-up information when people mouse over the bar chart.  For some reason though, when I enable this extra expression it causes extra data points to show up even though there is no data for it.

Textaspopup.PNG

Here you can see the graph with the extra data points.  They don't have any data like "DVHPYSN" does, but are still shown.

Does anyone have any ideas as to why this is happening?

Thanks for any help!

14 Replies
sunny_talwar

Use an if statement to display the pop-up information only when a data point exists. Assuming your first expression is the data point, you can try this

If(Len(Trim(Column(1)) > 0, Popup Text Expression)

shinnickr
Creator II
Creator II
Author

Hi Sunny,

Thanks for your help.

I did that but I'm getting an error in my expression. 

Textexpression.PNG

I tried messing around with it a little but couldn't figure out where it's getting the error.

sunny_talwar

Is this the expression for your text popup? Also, you have an extra parenthesis at the end also

shinnickr
Creator II
Creator II
Author

My expression for the popup has some set analysis in it, so I am just using this to make it easier when asking for advice.

And I'm not sure on the parenthesis. When I remove the last one, the edit expression box turns the parenthesis next to If red, indicating it's missing one.

Textangry.PNG

sunny_talwar

You need another parenthesis after Column(1))) to close for Len() function

shinnickr
Creator II
Creator II
Author

I just copied and pasted what you wrote out!  So I'm still blaming you. =0)

So it's sort of working now.

If I have just an expression in there, the popup text works and there are no extra data points.  But if I add text to it, the data points come back.

So

    This works - If(Len(Trim(Column(1)) > 0, Sum([Trach_Flg_Cnt]))

    But if I add some text to it like If(Len(Trim(Column(1)) > 0, 'Trach Flag Count = ' & Sum([Trach_Flg_Cnt])) ,then it adds those random data points again.

sunny_talwar

That was my bad ... try this

If(Len(Trim(Column(1))) > 0, 'Trach Flag Count = ' & Sum([Trach_Flg_Cnt]))

shinnickr
Creator II
Creator II
Author

Oops, see I missed the parenthesis there too.  Now we're even.... =P

That is what I have.  With the 'Trach Flag Count = ' the extra data points come back, but without it, they don't.

It's pretty weird....

sunny_talwar

That is weird, have you made sure that 'Suppress Zero Values' is checked on the presentation tab of the chart properties?