topic Count in QlikView

Count

MindaugasBacius — Tue, 22 Aug 2017 06:17:13 GMT

Hei,

I have data like below:

I need to create a Group field. The logic is that the Group depends on the order of the Year.

For example Price 2 appears in two intervals 2000-2001 and 2005-2006. That's two different groups.

I have attached the example file.

tresB — Tue, 22 Aug 2017 06:21:18 GMT

Can we generalize it that - the group is Year&Price-based ?

MindaugasBacius — Tue, 22 Aug 2017 06:23:39 GMT

Yes.

Also, the script needs to appear in back-end.

tresB — Tue, 22 Aug 2017 06:35:32 GMT

May be like:

tmp:

LOAD * INLINE

[ Year, Price

2000, 2

2001, 2

2002, 4

2003, 4

2004, 3

2005, 2

2006, 2

]

;

NoConcatenate

tmp2:

LOAD *,

if(Price=Peek('Price'), peek('Group'), RangeSum(Peek('Group'),1)) as Group

Resident tmp

Order By Year;

DROP Table tmp;