Get value to the left in pivot table in Qlik

Question

Is there a way to get the percentage of a value to its left in a pivot table?

For example, instead of the value 40 in Month May-22 i would like to show 54% instead ( % of 74) but the value 74 need to be shown as a full value of 74. Same with Jun-22, I would like to show 44% instead of 83 which is the percentage from 187.

Is this possible?

I've tried using set analysis for this but didn't work

SmoothBrane · Accepted Answer · 2023-03-28 23:22:09Z

0

You could try something like this:

=Sum(Expression1) & If(Not IsNull( Before(Sum(Expression1)) ), ' (' & Num(Sum(Expression1) / Before(Sum(Expression1)), '#,##0%') & ')')

...where Expression1 is your measure value.

This works by checking to see if the cell to the left is null and, if it's not, then putting the percentage in parentheses.

This is what I get (using randomly generated numbers):

answered Mar 28, 2023 at 23:22

SmoothBrane

9315 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get value to the left in pivot table in Qlik

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related