Count Dates by Week with Set Analysis

[miguelbraga]

Hi people,

I would like to know if there is anyway for me to count the amount of dates in a week using set analysis. For example, I have this table of values:

Date	Week
01/01/2013	2013/01
07/10/2013	2013/41
09/10/2013	2013/41
10/10/2013	2013/41
10/10/2013	2013/41
10/10/2013	2013/41
11/10/2013	2013/41

The results I need for this example are:

For Week -> 2013/01 the count number would be 1.

And for Week -> 2013/41 the count number would be 6.

How can I do this in a simple and clean way for me to understand? Bare in mind that I'm a begginer developer in both QlikView and Qlik Sense, just started a month ago.

Thanks for the help, Miguel.

[sunny_talwar]

If you add Week as a dimension and Count(Week) as your expression, you should get the result you are expecting to see.

[maxgro]

count(TOTAL <Week> distinct Date)

[sunny_talwar]

This:

[miguelbraga]

I've done this solution and it seems that the numbers for Week -> 2013/01 is 5 and for Week -> 2013/41 is 5.

[sasiparupudi1 · Accepted solution]

Please try this

[miguelbraga]

With this solution I could get my answer right!

Many thanks Mr. Sasidhar Parupudi. Have a nice week

[sasiparupudi1]

Hi Braga Miguel,

Your most welcome ,you too have a nice week.

Sasi

[maxgro]

see attachment

[tyagishaila]

count(Total<Week>Week)