topic Re: Getting an error with Text as Pop-Up in QlikView

Getting an error with Text as Pop-Up

ninnartx — Wed, 04 Apr 2018 09:24:42 GMT

Hi everyone,

Im getting "Drawing of chart failed internally" error when I tried to add an expression as Text as Pop-Up to my line chart.

I only get this error when the text as pop-up expression is above the line expression.

I don't get the error if my line expression is above my text as pop-up expression. However, in this case, when I hover over the chart, the text as pop-up expression does not appear.

If I choose to display data as straight table, there is no error. The values appear nicely on the table.

Unfortunately I cannot share a sample app, but if anyone could provide speculations as to why this is happening that'd be greatly appreciated!!! Thank you!

Re: Getting an error with Text as Pop-Up

rubenmarin — Wed, 04 Apr 2018 09:27:21 GMT

Hi Ninnart, seems a problem with the expression, can you share the expression used?

Re: Getting an error with Text as Pop-Up

ninnartx — Wed, 04 Apr 2018 09:52:12 GMT

The line chart is showing year-to-date %MS. And I would like show %Gr (comparing this YTD to previous year's YTD) when the users hover over the lines.

I'm not sure which expression is incorrect since all of them show up correctly when I display the data in a straight table...

First dimension: Qtr

Second dimension: Products

line expression (%MS):

aggr(

rangesum(above(sum({<Year=2017>}values), 0, RowNo())) /

rangesum(above(sum(TOTAL <Qtr> {<Year=2017>}values), 0, RowNo()))

, Products, Qtr)

text as pop-up expression (%Gr):

aggr(

rangesum(above(sum({<Year=2017>}values), 0, RowNo()))

, Products, Qtr)

aggr(

rangesum(above(sum({<Year=2016>}values), 0, RowNo()))

, Products, Qtr) - 1

Thanks so much for your time!

Re: Getting an error with Text as Pop-Up

rubenmarin — Wed, 04 Apr 2018 10:48:51 GMT

I think it's for the 2nd expression, have you tried?:

aggr(

rangesum(above(sum({<Year={2017}>}values), 0, RowNo()))

/ rangesum(above(sum({<Year={2016}>}values), 0, RowNo()))

, Products, Qtr) - 1

The first one also needs the {} in set analysis values.

Re: Getting an error with Text as Pop-Up

ninnartx — Wed, 04 Apr 2018 13:37:13 GMT

oh shoot sorry i missed the curly brackets in my example. the {} are there in the actual app. Is there anything else you think could be causing this issue?

Re: Getting an error with Text as Pop-Up

rubenmarin — Wed, 04 Apr 2018 13:39:04 GMT

Have you tried to change the 2nd expression to the one i posted before?

Re: Getting an error with Text as Pop-Up

ninnartx — Wed, 04 Apr 2018 13:49:25 GMT

Yes I did. still no luck

Re: Getting an error with Text as Pop-Up

rubenmarin — Wed, 04 Apr 2018 13:58:44 GMT

Seems to work for me, i will need a sample to check the differences.

Re: Getting an error with Text as Pop-Up

ninnartx — Wed, 04 Apr 2018 14:56:15 GMT

I tried to come up with a sample app too but could not replicate the error. My sample app works fine as well...

I'll keep digging and will update if i figure it out

Re: Getting an error with Text as Pop-Up

ninnartx — Thu, 05 Apr 2018 04:27:13 GMT

I figured it out! So I fixed the colors of my line chart using a basic RGB expression in Background Color. But did not add the same RGB expression to my Text as Pop-Up expression. (I didn't think the text as pop-up needed background colors???)

So when I added the same RGB expression to all my expressions, the error disappeared!