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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count data between dates

Hello..

We are facing a problem that we don't know how to solve.

We have user data, and some timestamp that the user has interact. there is a from and to date for each product, and them we have a months table with user and dates.

We need to count, how many user has data between the dates in that user data date (see table months).

We try several expressions, but we didn´t achieve a thing.

Thanks.

3 Replies
Anonymous
Not applicable
Author

Hi Gonzalo,

Please check attached

Hope that helps.

Anonymous
Not applicable
Author

You can also try

Count(DISTINCT YYYYMM_JOINED)

Not applicable
Author

Probably I express myself bad (or I explained it bad)...

What I want to know, is according From and to, the user is for every YYYYMM between that period, so it should only tell me true or false for each pair user-YYYYMM and after that, count the number of TRUE ocurrences..

Thanks for the help!