topic Re: conditional subtotal pivot in QlikView https://community.qlik.com/t5/QlikView/conditional-subtotal-pivot/m-p/625798#M230123 <HTML><HEAD></HEAD><BODY><P>I get an error opening your app, but anyway, I think you can't hide / disable subtotals based on dimension values.</P><P></P><P>You can however use dimensionality() / secondarydimensionality() in your expression to check if your expression is evaluated in subtotal context, then use a condition on Articletype to create what you want.</P></BODY></HTML> Tue, 11 Mar 2014 20:06:47 GMT swuehl 2014-03-11T20:06:47Z conditional subtotal pivot https://community.qlik.com/t5/QlikView/conditional-subtotal-pivot/m-p/625797#M230122 <HTML><HEAD></HEAD><BODY><P>hi. </P><P></P><P>is it possible to have conditional subtotaling based on a dimension?</P><P></P><P>for example i have two article types seperated by the first digit, i.e 9001, 8001. </P><P>when the article type = left(Articletype,1) = '8' i wish to supress totals or show 0 in the total cell, however when left(Articletype,1) = '9'</P><P>i wish to show the total in the Total cell.</P><P></P><P>i have attached my document for more insight.</P><P></P><P>Best</P><P>Brad</P></BODY></HTML> Tue, 11 Mar 2014 19:59:03 GMT https://community.qlik.com/t5/QlikView/conditional-subtotal-pivot/m-p/625797#M230122 2014-03-11T19:59:03Z Re: conditional subtotal pivot https://community.qlik.com/t5/QlikView/conditional-subtotal-pivot/m-p/625798#M230123 <HTML><HEAD></HEAD><BODY><P>I get an error opening your app, but anyway, I think you can't hide / disable subtotals based on dimension values.</P><P></P><P>You can however use dimensionality() / secondarydimensionality() in your expression to check if your expression is evaluated in subtotal context, then use a condition on Articletype to create what you want.</P></BODY></HTML> Tue, 11 Mar 2014 20:06:47 GMT https://community.qlik.com/t5/QlikView/conditional-subtotal-pivot/m-p/625798#M230123 swuehl 2014-03-11T20:06:47Z