Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Use of Dual() function in graph label

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

5 Replies

Re: Use of Dual() function in graph label

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.

MVP
MVP

Re: Use of Dual() function in graph label

Like this?

Not applicable

Re: Use of Dual() function in graph label

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

veidlburkhard
Contributor III

Re: Use of Dual() function in graph label

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:

TEST.jpg

Hope this helps

Burkhard

MVP
MVP

Re: Use of Dual() function in graph label

Attached a sample with multiple expressions.