topic Re: dynamic subtotal in QlikView https://community.qlik.com/t5/QlikView/dynamic-subtotal/m-p/1088841#M641012 <HTML><HEAD></HEAD><BODY><P>You can change the formatting of the cells, depending on the aggregation level, using DIMENSIONALITY() function.</P><P></P><P>Go to Expressions, expand the expression and change the "Background color" to something like:</P><P></P><P>=if(Dimensionality() = 1, red(), Blue())</P></BODY></HTML> Fri, 04 Mar 2016 11:52:17 GMT luciancotea 2016-03-04T11:52:17Z dynamic subtotal https://community.qlik.com/t5/QlikView/dynamic-subtotal/m-p/1088839#M641010 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: .0001pt; background: white;"><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Helvetica Neue'; color: #3d3d3d;">I've got a very simple pivot table with a grafic classification of the expression "importo totale" with 8 colours. (file trial)<BR /></SPAN></P><P></P><P style="margin-bottom: .0001pt; background: white;"><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Helvetica Neue'; color: #3d3d3d;">How can I've a sub-total of difference colours ?</SPAN></P><P style="margin-bottom: .0001pt;"></P><P style="margin-bottom: .0001pt;"><IMG alt="fd.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/116895_fd.jpg" style="height: auto;" /> </P><P></P><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="font-size: 10.0pt; font-family: 'Helvetica Neue'; color: #3d3d3d; background: white;">Thanks</SPAN></P></BODY></HTML> Thu, 03 Mar 2016 21:08:07 GMT https://community.qlik.com/t5/QlikView/dynamic-subtotal/m-p/1088839#M641010 marcorizzo 2016-03-03T21:08:07Z Re: dynamic subtotal https://community.qlik.com/t5/QlikView/dynamic-subtotal/m-p/1088840#M641011 <HTML><HEAD></HEAD><BODY><P>I suggest you creates within the script an additionally main-category to your sub-category and used then the partial-sum feature from the pivot-table. If this isn't suitable you could also create a <A href="https://community.qlik.com/qlik-blogpost/3676">Calculated Dimensions</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 04 Mar 2016 11:46:30 GMT https://community.qlik.com/t5/QlikView/dynamic-subtotal/m-p/1088840#M641011 marcus_sommer 2016-03-04T11:46:30Z Re: dynamic subtotal https://community.qlik.com/t5/QlikView/dynamic-subtotal/m-p/1088841#M641012 <HTML><HEAD></HEAD><BODY><P>You can change the formatting of the cells, depending on the aggregation level, using DIMENSIONALITY() function.</P><P></P><P>Go to Expressions, expand the expression and change the "Background color" to something like:</P><P></P><P>=if(Dimensionality() = 1, red(), Blue())</P></BODY></HTML> Fri, 04 Mar 2016 11:52:17 GMT https://community.qlik.com/t5/QlikView/dynamic-subtotal/m-p/1088841#M641012 luciancotea 2016-03-04T11:52:17Z