I have data in the following format in Qlik Sense:
Date | Customer | Flag |
2016-10-01 | A | 1 |
2016-10-01 | B | 0 |
2016-10-02 | A | 1 |
2016-10-02 | C | 1 |
2016-10-03 | A | 1 |
2016-10-03 | B | 1 |
2016-10-03 | C | 1 |
2016-10-05 | C | 1 |
2016-10-10 | A | 0 |
2016-10-10 | B | 1 |
2016-10-11 | C | 0 |
| | |
| | |
I would like to display the above data in a table in Qlik Sense in the following format:
Week Number | Count Distinct Customer Where Flag is 1 |
39 | 2 |
40 | 3 |
41 | 3 |
Logic Behind: I need Week wise count of DISTINCT Customers who have Flag = 1 in the that Week including one previous Week. So, here Week Number 40 will display distinct count for Week 39 and 40. Similarly Week 41 will display distinct count for Week 40 and 41 and so on.
I would appreciate if anyone can suggest a Qlik Sense expression for the above?
Thank you