topic chart expression: total keyword and calculated dimension in QlikView https://community.qlik.com/t5/QlikView/chart-expression-total-keyword-and-calculated-dimension/m-p/753124#M268361 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In my chart, I have a calculated dimensions that I would like to not ignore in the expression. There is one other calculated dimension that I would like to ignore. So there two calculated dimensions. I want to ignore want and take the other one in the group by of expression</P><P></P><P>my expression is something like</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1418820621032851" jivemacro_uid="_1418820621032851" modifiedtitle="true"> <P>sum(total rev)</P> </PRE><P></P><P>the expression for the rowbreakdim dimension that&nbsp; I dont want to ignore is</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14188206273949606" jivemacro_uid="_14188206273949606" modifiedtitle="true"> <P>=$(=if(GetSelectedCount(%SPMRowBreakDownSubOptionAlias)=0, '"'&amp; %SPMRowBreakDownOption &amp; '"', '"'&amp; %SPMRowBreakDownSubOption &amp; '"'))</P> </PRE><P></P><P>which I have labled as rowbreakdim and I want it not to be ignored in the expression</P><P></P><P>Can someone please tell me how to put this whole calculated dimension in the <STRONG>total</STRONG> key word in the chart expression If I have to ignore the other dimension but not this one?</P><P></P><P>Shah</P></BODY></HTML> Wed, 17 Dec 2014 12:56:36 GMT 2014-12-17T12:56:36Z chart expression: total keyword and calculated dimension https://community.qlik.com/t5/QlikView/chart-expression-total-keyword-and-calculated-dimension/m-p/753124#M268361 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In my chart, I have a calculated dimensions that I would like to not ignore in the expression. There is one other calculated dimension that I would like to ignore. So there two calculated dimensions. I want to ignore want and take the other one in the group by of expression</P><P></P><P>my expression is something like</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_1418820621032851" jivemacro_uid="_1418820621032851" modifiedtitle="true"> <P>sum(total rev)</P> </PRE><P></P><P>the expression for the rowbreakdim dimension that&nbsp; I dont want to ignore is</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14188206273949606" jivemacro_uid="_14188206273949606" modifiedtitle="true"> <P>=$(=if(GetSelectedCount(%SPMRowBreakDownSubOptionAlias)=0, '"'&amp; %SPMRowBreakDownOption &amp; '"', '"'&amp; %SPMRowBreakDownSubOption &amp; '"'))</P> </PRE><P></P><P>which I have labled as rowbreakdim and I want it not to be ignored in the expression</P><P></P><P>Can someone please tell me how to put this whole calculated dimension in the <STRONG>total</STRONG> key word in the chart expression If I have to ignore the other dimension but not this one?</P><P></P><P>Shah</P></BODY></HTML> Wed, 17 Dec 2014 12:56:36 GMT https://community.qlik.com/t5/QlikView/chart-expression-total-keyword-and-calculated-dimension/m-p/753124#M268361 2014-12-17T12:56:36Z