topic Re: Mouseover info in graph with two expressions in QlikView

Mouseover info in graph with two expressions

Wed, 25 Nov 2020 16:16:04 GMT

Hi all.

Referring to this thread: https://community.qlik.com/message/662370#662370

I want to be able to see 'n' (number of respondents) when looking at a chart with percentages.

My problem is that when I do what is suggested in the thread above I get the same 'n' for both lines(see picture below). The lines are two different expressions in the graph. How do I get the 'mouse over info pop up' to display the 'n' for the different lines in the graph. I am 100% sure that the 'n' is not the same for the two lines.

= 'n = ' & (count(Distinct %RespondentKEY))

Thank you

Re: Mouseover info in graph with two expressions

swuehl — Mon, 07 Mar 2016 23:47:16 GMT

No matter if n is the same or not for the two expressions,

your pop up expression

= 'n = ' & (count(Distinct %RespondentKEY))

is only calculated once per dimension value, it will return a single value for the Count().

So if you want to see to different numbers, I would assume that you need two aggregations.

What are the dimensions and expressions used in your chart? Could you post a small sample QVW?

Re: Mouseover info in graph with two expressions

Mon, 21 Mar 2016 08:30:42 GMT

Hi. I have included a qvw that shows what I want to achieve.

The test3 graph should show me the number in addition to the %number.

Does anyone know how I achieve that?

Thank you