Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

0 Replies