0 Replies Latest reply: Oct 20, 2016 10:54 AM by Hatim taj RSS

    Displaying data by time series aggregated by a given time period

    Hatim taj

      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