Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bmensing
Contributor III
Contributor III

Expression in Pivot works, using Variables not

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

1 Reply
oscar_ortiz
Partner - Specialist
Partner - Specialist

Try using dollar sign expansion.

$(vBS_ZuordBreite) * $(vBS_ZuordLaenge) / 1 000 000