Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis expr for subtotal

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

4 Replies
fernandotoledo
Partner - Specialist
Partner - Specialist

Add the month to your first statement:

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


Not applicable
Author

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.....

Not applicable
Author

This is Img 2

fernandotoledo
Partner - Specialist
Partner - Specialist

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.