topic Re: Use of Dual() function in graph label in QlikView

Use of Dual() function in graph label

Wed, 25 Nov 2020 16:16:04 GMT

Hi all.

Does anyone know how I can get the Dual() function to do what I want?

I want to be able to show both the percentage and the actual number.

In the qwv I have included in test3 is where I do not understand why it does not show me the number and the percentage.

Can someone please help me?

Thank you

Re: Use of Dual() function in graph label

sunny_talwar — Tue, 29 Mar 2016 14:06:02 GMT

I don't think this would be possible, because as soon as your set Integer as formatting the Dual's text part is replaced by its number part in the display.

Re: Use of Dual() function in graph label

swuehl — Tue, 29 Mar 2016 14:45:32 GMT

Like this?

Re: Use of Dual() function in graph label

Tue, 29 Mar 2016 15:05:54 GMT

Hi. No cause it still goes back to original when I change the format. I might have more than 1 expressions and need the pop up label to reflect the value of the exact bar (line).

I have survey question where the user needs to analyze on the percentage answered but also wants to see how many answered. So the numerator.......

Re: Use of Dual() function in graph label

veidlburkhard — Tue, 29 Mar 2016 15:12:02 GMT

Hi kjersti,

you'd better leave the number setting for the dual function as 'Expression Default' otherwise the dual function doesn't work.

For your expression test3 take: Avg(Amt)/Sum(Amt), for the second expression this is the right way:

Dual( Num(Avg(Amt)/Sum(Amt),'##.##%') &' / ' & Num(Avg(Amt), '#,##0'),Avg(Amt)/Sum(Amt))

See the picture:

Hope this helps

Burkhard

Re: Use of Dual() function in graph label

swuehl — Tue, 29 Mar 2016 19:01:46 GMT

Attached a sample with multiple expressions.