Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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.