Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

prasadp1
New Contributor

Repeat Case Analysis - 7days (Above & Below - Dates)

Count of repeat cases for past 7 days and next 7 days interval. count will varry day by day.

Example Data:

   

Sn NoDateCase
11/1/201823456
21/1/201834567
31/1/201867891
41/1/201891011
51/1/201891011
61/2/201801234
71/2/201823456
81/2/201834567
91/2/201867891
101/2/201891011
111/2/2018131415
121/3/201823456
131/3/201834567
141/3/201889101
151/3/201889101
161/3/201891011
171/3/2018131415
181/4/201801234
191/4/201801234
201/4/201812345
211/4/201867891
221/4/201889101
231/4/201891011
241/4/2018111213
251/4/2018121314
261/4/2018141516
271/4/2018151617
281/5/201812345
291/5/201823456
301/5/201845678
311/5/201856789
321/5/201878910
331/5/2018111213
341/5/2018121314
351/5/2018131415
361/5/2018141516
371/6/201845678
381/6/201856789
391/6/201889101
401/6/2018101112
411/6/2018101112
421/6/2018121314
431/7/201812345
441/7/201845678
451/7/201845678
461/7/201856789
471/7/201856789
481/7/201878910
491/7/201891011
501/7/2018131415
511/7/2018141516
521/7/2018151617
Tags (1)
2 Replies
MVP
MVP

Re: Repeat Case Analysis - 7days (Above & Below - Dates)

What is the expected output based on the above sample data?

prasadp1
New Contributor

Re: Repeat Case Analysis - 7days (Above & Below - Dates)

Basically need to get a count of cases which is repeated for above and below 7 date (Rolling Days).

Ex: Case 91011 is there on 1/1/2018, 1/2/2018, 1/3/2018, 1/4/2018

Date          Case     Count     Day wise Interval Count

1/1/2018   91011       1                      4

1/2/2018   91011       1                      4

1/3/2018   91011       1                      4

1/4/2018   91011       1                      4