topic Re: Variable as dimension in QlikView https://community.qlik.com/t5/QlikView/Variable-as-dimension/m-p/704560#M254087 <HTML><HEAD></HEAD><BODY><P>Please share the sample application</P></BODY></HTML> Fri, 26 Sep 2014 12:24:05 GMT svsudhakar 2014-09-26T12:24:05Z Variable as dimension https://community.qlik.com/t5/QlikView/Variable-as-dimension/m-p/704558#M254085 <HTML><HEAD></HEAD><BODY><P>I have the following code as a dimension.</P><P></P><P>When I place it in the pivot table as dimension it works.</P><P></P><P>=aggr(Sum({&lt; DisplayCobDate =, [CobDate]={'$(vDate)'} &gt;}$(avariable)),[FieldName])</P><P></P><P>If I then use a variable name test and place =$(test) in the dimension it does not work.</P><P></P><P>What do I need to do to get this working?</P></BODY></HTML> Fri, 26 Sep 2014 12:09:47 GMT https://community.qlik.com/t5/QlikView/Variable-as-dimension/m-p/704558#M254085 alan_grn 2014-09-26T12:09:47Z Re: Variable as dimension https://community.qlik.com/t5/QlikView/Variable-as-dimension/m-p/704559#M254086 <HTML><HEAD></HEAD><BODY><P>Go through this thread <A _jive_internal="true" href="https://community.qlik.com/message/605513#605513">http://community.qlik.com/message/605513#605513</A></P></BODY></HTML> Fri, 26 Sep 2014 12:12:36 GMT https://community.qlik.com/t5/QlikView/Variable-as-dimension/m-p/704559#M254086 senpradip007 2014-09-26T12:12:36Z Re: Variable as dimension https://community.qlik.com/t5/QlikView/Variable-as-dimension/m-p/704560#M254087 <HTML><HEAD></HEAD><BODY><P>Please share the sample application</P></BODY></HTML> Fri, 26 Sep 2014 12:24:05 GMT https://community.qlik.com/t5/QlikView/Variable-as-dimension/m-p/704560#M254087 svsudhakar 2014-09-26T12:24:05Z Re: Variable as dimension https://community.qlik.com/t5/QlikView/Variable-as-dimension/m-p/704561#M254088 <HTML><HEAD></HEAD><BODY><P>Ty this (with single quotes incl). It will get you something like the chart below.</P><P></P><P>='$(test)'</P><P></P><P></P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67747_Capture.PNG.png" /></P></BODY></HTML> Fri, 26 Sep 2014 12:59:10 GMT https://community.qlik.com/t5/QlikView/Variable-as-dimension/m-p/704561#M254088 JonnyPoole 2014-09-26T12:59:10Z