topic How to store calculated single dimension value in a variable in QlikView https://community.qlik.com/t5/QlikView/How-to-store-calculated-single-dimension-value-in-a-variable/m-p/171107#M41256 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i am using the following formula in a gauge chart to show the MTD growth(can't use direct InMonthTodate, because there is a different calendar used in the date field.)</P><P></P><P>=<STRONG>if(KOMONTH=vCurr_KOMONTH,aggr</STRONG>((Sum({&lt;YEAR=,KOMONTH=,DAY=&gt;} InYearToDate(BILL_DATE,'$(MaxDate)',0,1) * -1 * CCIQUANTITY*CCIUNIT_CASE) - Sum({&lt;YEAR=,KOMONTH=,DAY=&gt;} InYearToDate(BILL_DATE,'$(MaxDate)',-1,1) * -1 * CCIQUANTITY*CCIUNIT_CASE)) / (Sum({&lt;YEAR=,KOMONTH=,DAY=&gt;} InYearToDate(BILL_DATE,'$(MaxDate)',-1,1) * -1 * CCIQUANTITY*CCIUNIT_CASE)),KOMONTH)) .</P><P>This gives true value in a list box. But no value in a Textbox or in the GAUGE chart. i suspect this is because of dimension(use AGGR function).</P><P>OR simply guide me HOW CAN I STORE THIS(result) in a VARIABLE.</P><P>Anybody with a solution thought is appreciated.</P><P>With regards,</P><P>tresesco</P><BR /><BR /></BODY></HTML> Mon, 23 Aug 2010 12:43:00 GMT tresB 2010-08-23T12:43:00Z How to store calculated single dimension value in a variable https://community.qlik.com/t5/QlikView/How-to-store-calculated-single-dimension-value-in-a-variable/m-p/171107#M41256 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>i am using the following formula in a gauge chart to show the MTD growth(can't use direct InMonthTodate, because there is a different calendar used in the date field.)</P><P></P><P>=<STRONG>if(KOMONTH=vCurr_KOMONTH,aggr</STRONG>((Sum({&lt;YEAR=,KOMONTH=,DAY=&gt;} InYearToDate(BILL_DATE,'$(MaxDate)',0,1) * -1 * CCIQUANTITY*CCIUNIT_CASE) - Sum({&lt;YEAR=,KOMONTH=,DAY=&gt;} InYearToDate(BILL_DATE,'$(MaxDate)',-1,1) * -1 * CCIQUANTITY*CCIUNIT_CASE)) / (Sum({&lt;YEAR=,KOMONTH=,DAY=&gt;} InYearToDate(BILL_DATE,'$(MaxDate)',-1,1) * -1 * CCIQUANTITY*CCIUNIT_CASE)),KOMONTH)) .</P><P>This gives true value in a list box. But no value in a Textbox or in the GAUGE chart. i suspect this is because of dimension(use AGGR function).</P><P>OR simply guide me HOW CAN I STORE THIS(result) in a VARIABLE.</P><P>Anybody with a solution thought is appreciated.</P><P>With regards,</P><P>tresesco</P><BR /><BR /></BODY></HTML> Mon, 23 Aug 2010 12:43:00 GMT https://community.qlik.com/t5/QlikView/How-to-store-calculated-single-dimension-value-in-a-variable/m-p/171107#M41256 tresB 2010-08-23T12:43:00Z How to store calculated single dimension value in a variable https://community.qlik.com/t5/QlikView/How-to-store-calculated-single-dimension-value-in-a-variable/m-p/171108#M41257 <HTML><HEAD></HEAD><BODY><P>Hey............I have got the solution!!!</P><P>The IF was the culprit. I simply replaced the if with Set analysis accordingly.....and then i was done.</P><P></P><P>enjoy QV!</P></BODY></HTML> Mon, 23 Aug 2010 14:55:10 GMT https://community.qlik.com/t5/QlikView/How-to-store-calculated-single-dimension-value-in-a-variable/m-p/171108#M41257 tresB 2010-08-23T14:55:10Z