Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Add percentage values row based on other unique numeric row in the same table chart.

Hello everyone,

This is my problem.

I have a Table chart with only one row :

Num1 Num2 Num3

150      80         70

Num2 and Num3 are part of Num1 (Num2+Num3 = Num1)

I would like to add another row in this table where I can have a final table like this one.

          Num1 Num2 Num3

value 150     80          70

perc    150     53%     47%

I saw something like that in the community long time ago, but I wasn't able to find it again.

NB. Num1 Num2 and Num 3 are expressions.

Thank you in advance.

1 Reply
Highlighted
MVP
MVP

Create Pivot Table

Dimensions:

1) Valuelist ('Value','Perc')

2) Valuelist ('Num1','Num2','Num3')

Expression:

If(Valuelist ('Value','Perc')='Value' and Valuelist ('Num1','Num2','Num3') ='Num1',

Num1Expression,

If(Valuelist ('Value','Perc')='Value' and Valuelist ('Num1','Num2','Num3') ='Num2',

Num2Expression,

If(Valuelist ('Value','Perc')='Value' and Valuelist ('Num1','Num2','Num3') ='Num3',

Num3Expression,

f(Valuelist ('Value','Perc')='Perc' and Valuelist ('Num1','Num2','Num3') ='Num1',

Num1Expression,

If(Valuelist ('Value','Perc')='Perc' and Valuelist ('Num1','Num2','Num3') ='Num2',

num(Num1Expression/Num2Expression,'#0.00%'),

If(Valuelist ('Value','Perc')='Perc' and Valuelist ('Num1','Num2','Num3') ='Num3',

num(Num1Expression/Num3Expression,'#0.00%')))))))


Drag the Num dimension on Expression