topic Re: Pivot table row stripping based on top level in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-row-stripping-based-on-top-level/m-p/512866#M191628 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>=if(sum( total &lt;Parent&gt; odd(aggr(rowno(),Parent)))&lt;0,rgb(160,160,160),rgb(255,255,255))</P></BODY></HTML> Tue, 12 Nov 2013 17:56:34 GMT Carlos_Reyes 2013-11-12T17:56:34Z Pivot table row stripping based on top level https://community.qlik.com/t5/QlikView/Pivot-table-row-stripping-based-on-top-level/m-p/512865#M191627 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Hi</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">I think I am nearly there, just need a little guidance.</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">I want to shade every other PivotTable row based on the first dimension level.</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><BR /></SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Thanks</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;">Oli</SPAN></P><P><SPAN style="font-family: calibri,verdana,arial,sans-serif;"><BR /></SPAN></P></BODY></HTML> Tue, 12 Nov 2013 12:07:03 GMT https://community.qlik.com/t5/QlikView/Pivot-table-row-stripping-based-on-top-level/m-p/512865#M191627 2013-11-12T12:07:03Z Re: Pivot table row stripping based on top level https://community.qlik.com/t5/QlikView/Pivot-table-row-stripping-based-on-top-level/m-p/512866#M191628 <HTML><HEAD></HEAD><BODY><P>Try:</P><P></P><P>=if(sum( total &lt;Parent&gt; odd(aggr(rowno(),Parent)))&lt;0,rgb(160,160,160),rgb(255,255,255))</P></BODY></HTML> Tue, 12 Nov 2013 17:56:34 GMT https://community.qlik.com/t5/QlikView/Pivot-table-row-stripping-based-on-top-level/m-p/512866#M191628 Carlos_Reyes 2013-11-12T17:56:34Z Re: Pivot table row stripping based on top level https://community.qlik.com/t5/QlikView/Pivot-table-row-stripping-based-on-top-level/m-p/512867#M191629 <HTML><HEAD></HEAD><BODY><P>Thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 13 Nov 2013 08:37:10 GMT https://community.qlik.com/t5/QlikView/Pivot-table-row-stripping-based-on-top-level/m-p/512867#M191629 2013-11-13T08:37:10Z