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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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.