topic How to make caption dynamic for two different dimension and also calculate sum accordingly. in QlikView https://community.qlik.com/t5/QlikView/How-to-make-caption-dynamic-for-two-different-dimension-and-also/m-p/482199#M180209 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have two dimensions in two different list boxes, Months and Years. I have a pivot chart where I am calculating the sum based out of these two dimensions. The dimension Months has values from 'Jan' to 'Dec' while Years has 2011, 2012 and 2013. Please find the attached image. Questions:</P><P>1) The sum of the chart should be displayed upon the combination of dimensions. For example: if I choose 2011, it should show&nbsp; all months and total sale against each of them. Or, if I choose Month 'Feb' it should show all the years (2011 to 2013) and total against those individual years. And, if I choose both the Month and Year, the respective total should appear for the combination should appear.</P><P>2)I want to the caption dynamic containing whichever dimension I choose. In case I choose, both the dimensions both should appear in caption.</P><P></P><P>Thanks!!!</P></BODY></HTML> Fri, 13 Dec 2013 11:59:41 GMT 2013-12-13T11:59:41Z How to make caption dynamic for two different dimension and also calculate sum accordingly. https://community.qlik.com/t5/QlikView/How-to-make-caption-dynamic-for-two-different-dimension-and-also/m-p/482199#M180209 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have two dimensions in two different list boxes, Months and Years. I have a pivot chart where I am calculating the sum based out of these two dimensions. The dimension Months has values from 'Jan' to 'Dec' while Years has 2011, 2012 and 2013. Please find the attached image. Questions:</P><P>1) The sum of the chart should be displayed upon the combination of dimensions. For example: if I choose 2011, it should show&nbsp; all months and total sale against each of them. Or, if I choose Month 'Feb' it should show all the years (2011 to 2013) and total against those individual years. And, if I choose both the Month and Year, the respective total should appear for the combination should appear.</P><P>2)I want to the caption dynamic containing whichever dimension I choose. In case I choose, both the dimensions both should appear in caption.</P><P></P><P>Thanks!!!</P></BODY></HTML> Fri, 13 Dec 2013 11:59:41 GMT https://community.qlik.com/t5/QlikView/How-to-make-caption-dynamic-for-two-different-dimension-and-also/m-p/482199#M180209 2013-12-13T11:59:41Z Re: How to make caption dynamic for two different dimension and also calculate sum accordingly. https://community.qlik.com/t5/QlikView/How-to-make-caption-dynamic-for-two-different-dimension-and-also/m-p/482200#M180210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>QlikView will aggregate values according to your selections, so that first point seems to be already fixed.</P><P></P><P>As for the dynamic caption, there are several ways to do it, here is one:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13869365498131957" jivemacro_uid="_13869365498131957" modifiedtitle="true"> <P>='Values for: ' &amp; If(Count(DISTINCT Year) = 1, GetFieldSelections(Year),</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; If(Count(DISTINCT Month) = 1, GetFieldSelections(Month)</P> <P>&nbsp;&nbsp;&nbsp;&nbsp; )</P> </PRE><P></P><P>Miguel</P></BODY></HTML> Fri, 13 Dec 2013 12:11:08 GMT https://community.qlik.com/t5/QlikView/How-to-make-caption-dynamic-for-two-different-dimension-and-also/m-p/482200#M180210 Miguel_Angel_Baeyens 2013-12-13T12:11:08Z