Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning together,
i am a Beginner in Qlikview and i need help in using variables to store expressions.
The Expression i got in the Pivot is as follows:
BS_Zuord.Auspr * if(BS_Zuord.Merkmale = 'Breite', 1, 0)
and that works fine, but i want to create several variables as
vBS_ZuordBreite and the same Definition as in the Expression
BS_Zuord.Auspr * if(BS_Zuord.Merkmale = 'Breite', 1, 0)
vBS_ZuordLaenge
BS_Zuord.Auspr * if(BS_Zuord.Merkmale = 'Laenge', 1,0)
now i want to use the variable in the Expression of the pivot, like
vBS_ZuordBreite * vBS_ZuordLaenge / 1 000 000
but it wont work, any ideas?
Best regards
Try using dollar sign expansion.
$(vBS_ZuordBreite) * $(vBS_ZuordLaenge) / 1 000 000