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.
