topic Re: Count data between dates in QlikView

Count data between dates

Thu, 03 Oct 2013 14:14:17 GMT

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.

Re: Count data between dates

Anonymous — Thu, 03 Oct 2013 14:20:40 GMT

Hi Gonzalo,

Please check attached

Hope that helps.

Re: Count data between dates

Anonymous — Thu, 03 Oct 2013 14:29:58 GMT

You can also try

Count(DISTINCT YYYYMM_JOINED)

Re: Count data between dates

Thu, 03 Oct 2013 14:34:31 GMT

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!