Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Wondering if anyone has any ideas - I want to have a dimension (say field_a) within a straight table, but I only want to display the value of Field_a that matches the value in a variable x.
So for example, say we have field_A with the unique values as:
field_a
-------
a
b
c
d
e1
e2
etc.
Variable x has value c, then I only want the straight table to show the value c.
Guess I can use set analysis to solve this - within the dimension somehow, but not quite sure how. Any suggestions?
Regards,
Revlin
Click on AddCalculationDimension and use this code there
=If(Field_A='$(Variable)',Field_A)
Now click on OK & check Supprss when value is null.
Hope it helps you
Cheers!
Jagan
try this:
Click on AddCalculationDimension and use this code there
=If(Field_A='$(Variable)',Field_A)
Now click on OK & check Supprss when value is null.
Hope it helps you
Cheers!
Jagan
Hi - sorry I only have the free version of Qlikview so cannot open any other files.
Is it a dimention expression you could paste in here?
Thank you Jagan!