topic Selective subtotals in QlikView

Selective subtotals

NickP_DF — Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

in a pivot table with subtotals I'd like to show the subtotals line with the values if the above details row count is greater then 1 and otherwise the subtotals line without the values.

I've tried to work with the Custom format cell by setting the text color equal to the background color if the details row number is 1, but it doesn't work.

Have you got a trick to suggest to me, pls?

(I give a little example about my aim)

Thanks.

Re: Selective subtotals

Kushal_Chawda — Sat, 12 Sep 2020 21:00:19 GMT

@NickP_DF try below

Data: LOAD * Inline [ Team,Player,Wins aa,a,100 aa,b,50 bb,c,40 cc,d,90 cc,e,110 dd,f,60 ];

Put below formula in Background color and Text color for measure and Player dimension

=if(sum(total <Team>aggr(Count(Player),Team))=1 and Dimensionality()=1, LightGray())

Re: Selective subtotals

NickP_DF — Tue, 15 Sep 2020 15:32:35 GMT

Great suggestion, Kush!

Thank you so much.