Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaytrip
Creator
Creator

Keeping the Total Count Constant

Hi Guys ,

So I have a query where I'd want to show the total count which is shown in the two images here below.

month.PNG

But as soon as I make a Selection I must have the total count not change for any of the selections made.

So that I can tally from the count of the month vs the total count that was made entirely.

check2.PNGcheck.PNG

How should I Proceed Further ?

Thanks for help !


Regards,

Abhay

4 Replies
stabben23
Partner - Master
Partner - Master

add {1} inside Your countexpression maybe

Anonymous
Not applicable

count({1} Total Fieldname)

supriyabiware
Creator
Creator

maybe in Total count expression - Sum(Total <your dimension> Count) or just Sum(Total Count)

abhaytrip
Creator
Creator
Author

Oh yes , That did help !
Thanks alot
Since im new to Qlik , im learning from yall.