Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a requirement as follows:
I have a pivot table with one dimension say, "Plant Name" and one expression which is "Expression1" with values as shown below. Now i need to have one more expression in my pivot table which has the following condition: Say for example, for "Plant Name" A, "Expression2" should be: value in "Expression1" (i.e. 20) divided by sum of the values in column "Expression1" (i.e. 60 in our case here) multiplied by 100.
Plant Name | Expression1 | Expression2 |
---|---|---|
A | 20 | (20/60)*100 |
B | 10 | (10/60)*100 |
C | 30 | (30/60)*100 |
Is it possible to achieve this in QlikView?
Any suggestions?
Thank you.
Hi,
You can use the following expression (as Expression2) to achieve this result:
Expression1/sum(TOTAL Expression1)*100
If you want to show the result in percentage, you can change the expression to Expression1/sum(TOTAL Expression1) and format the number as %
Hope this helps you
Eduardo
Hello Eduardo,
Thank you for the help.
This expression is working fine for the example that i have provided here, but somehow its not working with my original data. I will find out the reason for that.
Anyways thank you once again for the help.
Regards,
Apoorva
Hi,
Let me ask you something: is there any other dimensionamento in your pivot table?
Eduardo
Hi Eduardo,
No, there is no other dimension in my Pivot table except "Plant Name".
Thank you.
What is the exact expression you are using?