I am using the April-2018 version in qliksense. I want to create a pivot table contains the two dimension (region, status) and three expression(Budget,Actual,Ach or Diff).
In these region dimension as row and status as column and in 3 expression the label need to change when status is volume then it should show as 'Ach' other wise 'diff'.
when i was trying to have a expression in the label box as If(status='volume','Ach','Diff') , it was showing label as 'Diff' only.
I am struck on the label name. Kindly provide your suggestions on this, it would be helpful for me.
The below is the required out.
Thanks in advance
Thanks for your reply,
I tried with this option also but the output it was coming always as 'Diff'.The if condition is always false and it comes only when i a make filter on status column as "Volume"