topic set analysis expr for subtotal in QlikView

set analysis expr for subtotal

Mon, 07 Jun 2010 19:32:00 GMT

How to Combine these to set analysis expressions

1) Count( {1<Call= {Phone} >} Call )

2) Count(Total <Mon> Call )

I want each month subtotal whose call type is Phone

thanks in advance

fernandotoledo — Mon, 07 Jun 2010 19:46:19 GMT

Add the month to your first statement:

{1<Call='Phone',Mon='1'.}

Mon, 07 Jun 2010 20:18:52 GMT

Thanks for your reply... but does not solves my problem

Img1 is my chart, img 2 is how I want to populate with the month total in the totals column.. Ex: - 121 for Apr 09.....

Mon, 07 Jun 2010 20:19:46 GMT

This is Img 2

fernandotoledo — Wed, 09 Jun 2010 16:37:48 GMT

oh, instead using set analisys in this case, what about a calculated dimension like

if(Type='Phone',Type,null())

then check this dimension´s "Suppress when field is null" Dimensions tab option. The sum expression will simple Sum(value) one.