Solved: Expression Label - Calculated - Qlik Community

pkelly · ‎2010-10-07

Hi all...

To arrive at the format my user wants, I had to create a stand alone data table.

A snapshot is attached...

I now have a field which basically means two things...

1) GM%

2) PP (Percentage Points)

I want the labels to be different depending upon what the Region value equals (the snapshot illustrates this).

I have tried an IF statement but with no success - any ideas?

Regards

Paul

Report Inappropriate Content · ‎2010-10-07

I have tried some examples and could never make the Expression name talk to the dimension field. have tried using the inter-registry, but expression and its names does not seem to mix. The expression name seems only to work with variables.

You could try to make 2 tables, 1 with all values and the other only with Z-Var and put them together making sure they seem only one. Not the best solution, but a workaround solution.

View solution in original post

pkelly · ‎2010-10-07

Here is the snapshot - posted the wrong one with original post...

Report Inappropriate Content · ‎2010-10-07

I have tried some examples and could never make the Expression name talk to the dimension field. have tried using the inter-registry, but expression and its names does not seem to mix. The expression name seems only to work with variables.

You could try to make 2 tables, 1 with all values and the other only with Z-Var and put them together making sure they seem only one. Not the best solution, but a workaround solution.