topic variable confusion = or not in QlikView https://community.qlik.com/t5/QlikView/variable-confusion-or-not/m-p/376151#M140193 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a number of variables created which I reference in a pivot, in my expression that references the variables it shows blank unless I filter 1 record in the dimension used in the pivot and change the variable to have an = before it.&nbsp; </P><P>I believe it is something to do with aggregation so in the variable I have then placed an aggr and aggregated it based on the dimension in question however this doesnt work.</P><P></P><P>can someone please help</P></BODY></HTML> Wed, 08 Aug 2012 13:04:49 GMT 2012-08-08T13:04:49Z variable confusion = or not https://community.qlik.com/t5/QlikView/variable-confusion-or-not/m-p/376151#M140193 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a number of variables created which I reference in a pivot, in my expression that references the variables it shows blank unless I filter 1 record in the dimension used in the pivot and change the variable to have an = before it.&nbsp; </P><P>I believe it is something to do with aggregation so in the variable I have then placed an aggr and aggregated it based on the dimension in question however this doesnt work.</P><P></P><P>can someone please help</P></BODY></HTML> Wed, 08 Aug 2012 13:04:49 GMT https://community.qlik.com/t5/QlikView/variable-confusion-or-not/m-p/376151#M140193 2012-08-08T13:04:49Z Re: variable confusion = or not https://community.qlik.com/t5/QlikView/variable-confusion-or-not/m-p/376152#M140194 <HTML><HEAD></HEAD><BODY><P>at least paste the chart expression</P><P></P><P>are the variables simply a value or they are calculated by expresion?</P></BODY></HTML> Wed, 08 Aug 2012 13:38:46 GMT https://community.qlik.com/t5/QlikView/variable-confusion-or-not/m-p/376152#M140194 2012-08-08T13:38:46Z Re: variable confusion = or not https://community.qlik.com/t5/QlikView/variable-confusion-or-not/m-p/376153#M140195 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You may define the variable without = sign before it. e.g <STRONG>sum(Filed1) / Sum(Fileld_2).&nbsp; </STRONG>In chart expression use the variable as <STRONG>$(variable_name).</STRONG></P><P></P><P>Regards,</P><P>Som</P></BODY></HTML> Wed, 08 Aug 2012 15:50:27 GMT https://community.qlik.com/t5/QlikView/variable-confusion-or-not/m-p/376153#M140195 somenathroy 2012-08-08T15:50:27Z