Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help using "Dual" function to display 2 values in a single column

I am using a cross table which has quite a few expressions in it, the last expression is a total column which I would like to display the actual amount of something, and it's % of the total.

There is also a subtotal row, so the very bottom right box is the subtotal of the total column.

So for example if the last column's values were:

10

50

40

100

where 100 is the subtotal, I would want it to display as:

10 (10%)

50 (50%)

40 (40%)

100

Any tips on using the dual function to accomplish this?

2 Replies
MK_QSL
MVP
MVP

IF(Dimensionality()=1,SUM(Value) & ' ' & NUM(SUM(Value)/SUM(TOTAL Value),'#,##0.00%'),SUM(TOTAL Value))

Or

IF(Dimensionality()=1,SUM(Value) & ' ' &'('&NUM(SUM(Value)/SUM(TOTAL Value),'#,##0%')&')',SUM(TOTAL Value))

Not applicable
Author

Hi Stephan

Dual seems to be the proper solution. Probably in combination with Dimensionality() function.

Please upload your example if you want the solution

Lukasz