Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hatimtaj
New Contributor

Displaying data by time series aggregated by a given time period

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

Community Browser