topic how to get last 2 year rolling store count in table in QlikView

how to get last 2 year rolling store count in table

sushil353 — Wed, 22 Apr 2015 16:03:43 GMT

Hi All,

I need to calculate count of stores for each year which opened in last to last year.

My input data is

Test:

Load * inline

[

Storeid,YearofOpen

1,2010

2,2010

3,2011

4,2011

5,2012

6,2013

7,2013

8,2014

9,2015

];

desired output:

It seems the logic is simple but I am not getting any clue to get it solved.

Please help to get the logic solved.

Thanks in advance

Sushil

Anonymous — Wed, 22 Apr 2015 16:12:13 GMT

Yes, it is simple, see attached.

The expression is

rangesum(above(count(distinct Storeid),2, rowno()))

Wed, 22 Apr 2015 16:15:37 GMT

Hi!

Try This:

Create a new table Chart

Define as Dimension: Storeid

Define one expresion as: Count( Distinct(Storeid))

Let me know If works!

Cheers!