topic Expression in Pivot works, using Variables not in QlikView https://community.qlik.com/t5/QlikView/Expression-in-Pivot-works-using-Variables-not/m-p/1098130#M902387 <HTML><HEAD></HEAD><BODY><P>Good Morning together,</P><P></P><P>i am a Beginner in Qlikview and i need help in using variables to store expressions.</P><P></P><P>The Expression i got in the Pivot is as follows:</P><P></P><P>BS_Zuord.Auspr * if(BS_Zuord.Merkmale = 'Breite', 1, 0)</P><P></P><P>and that works fine, but i want to create several variables as</P><P></P><P><STRONG>vBS_ZuordBreite </STRONG>and the same Definition as in the Expression</P><P>BS_Zuord.Auspr * if(BS_Zuord.Merkmale = 'Breite', 1, 0)</P><P></P><P><STRONG>vBS_ZuordLaenge </STRONG></P><P>BS_Zuord.Auspr * if(BS_Zuord.Merkmale = 'Laenge', 1,0)</P><P></P><P></P><P>now i want to use the variable in the Expression of the pivot, like</P><P></P><P>vBS_ZuordBreite * vBS_ZuordLaenge / 1 000 000</P><P></P><P>but it wont work, any ideas?</P><P></P><P>Best regards</P><P></P><P></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bmensing 2020-11-25T16:16:04Z Expression in Pivot works, using Variables not https://community.qlik.com/t5/QlikView/Expression-in-Pivot-works-using-Variables-not/m-p/1098130#M902387 <HTML><HEAD></HEAD><BODY><P>Good Morning together,</P><P></P><P>i am a Beginner in Qlikview and i need help in using variables to store expressions.</P><P></P><P>The Expression i got in the Pivot is as follows:</P><P></P><P>BS_Zuord.Auspr * if(BS_Zuord.Merkmale = 'Breite', 1, 0)</P><P></P><P>and that works fine, but i want to create several variables as</P><P></P><P><STRONG>vBS_ZuordBreite </STRONG>and the same Definition as in the Expression</P><P>BS_Zuord.Auspr * if(BS_Zuord.Merkmale = 'Breite', 1, 0)</P><P></P><P><STRONG>vBS_ZuordLaenge </STRONG></P><P>BS_Zuord.Auspr * if(BS_Zuord.Merkmale = 'Laenge', 1,0)</P><P></P><P></P><P>now i want to use the variable in the Expression of the pivot, like</P><P></P><P>vBS_ZuordBreite * vBS_ZuordLaenge / 1 000 000</P><P></P><P>but it wont work, any ideas?</P><P></P><P>Best regards</P><P></P><P></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-in-Pivot-works-using-Variables-not/m-p/1098130#M902387 bmensing 2020-11-25T16:16:04Z Re: Expression in Pivot works, using Variables not https://community.qlik.com/t5/QlikView/Expression-in-Pivot-works-using-Variables-not/m-p/1098131#M902388 <HTML><HEAD></HEAD><BODY><P>Try using dollar sign expansion.</P><P></P><P>$(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">vBS_ZuordBreite) * $(vBS_ZuordLaenge) / 1 000 000</SPAN></P></BODY></HTML> Wed, 06 Jul 2016 08:59:25 GMT https://community.qlik.com/t5/QlikView/Expression-in-Pivot-works-using-Variables-not/m-p/1098131#M902388 oscar_ortiz 2016-07-06T08:59:25Z