topic Re: Text as popup causing extra data points to appear in QlikView

Text as popup causing extra data points to appear

shinnickr — Wed, 25 Nov 2020 16:16:04 GMT

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.

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!

Re: Text as popup causing extra data points to appear

sunny_talwar — Thu, 25 Jan 2018 18:59:25 GMT

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)

Re: Text as popup causing extra data points to appear

shinnickr — Thu, 25 Jan 2018 19:18:48 GMT

Hi Sunny,

Thanks for your help.

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

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

Re: Text as popup causing extra data points to appear

sunny_talwar — Thu, 25 Jan 2018 19:30:46 GMT

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

Re: Text as popup causing extra data points to appear

shinnickr — Thu, 25 Jan 2018 19:41:40 GMT

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.

Re: Text as popup causing extra data points to appear

sunny_talwar — Thu, 25 Jan 2018 19:43:14 GMT

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

Re: Text as popup causing extra data points to appear

shinnickr — Thu, 25 Jan 2018 20:09:02 GMT

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.

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.

Re: Text as popup causing extra data points to appear

sunny_talwar — Thu, 25 Jan 2018 20:10:25 GMT

That was my bad ... try this

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

Re: Text as popup causing extra data points to appear

shinnickr — Thu, 25 Jan 2018 20:14:49 GMT

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....

Re: Text as popup causing extra data points to appear

sunny_talwar — Thu, 25 Jan 2018 20:16:22 GMT

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

Re: Text as popup causing extra data points to appear

shinnickr — Thu, 25 Jan 2018 20:33:48 GMT

Yup, unfortunately that is already checked on.

Re: Text as popup causing extra data points to appear

sunny_talwar — Thu, 25 Jan 2018 20:34:28 GMT

Unless you are able to share a sample to show me the issue.... I am out of ideas

Re: Text as popup causing extra data points to appear

shinnickr — Thu, 25 Jan 2018 20:42:27 GMT

Unfortunately my app has sensitive data and I could get in trouble for sharing it. I know about the scrambling and everything, but I am just not sure this small problem is worth risking my job.

That's okay. I really appreciate the help though!

Re: Text as popup causing extra data points to appear

sunny_talwar — Thu, 25 Jan 2018 20:49:47 GMT

Sounds good

Re: Text as popup causing extra data points to appear

shinnickr — Thu, 25 Jan 2018 20:54:28 GMT

You rock Sunny =0)