Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count everything but current month


ok. I have to count the distinct number of users for the current month and compare that to the total users that have ever been seen.

The calculation is easy, but what I'd like to do is when the user selects a different period, I'd like to have this calculation be correct for the total number of users that have ever been seen with respect to the month selected.

2 Replies
swuehl
MVP
MVP

Maybe like

=Count({1-$} Distinct User)

PrashantSangle

Hi,

Something like this for total user

Count({<Period=>} Total User)

regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂