topic Re: Create flags to count Unique in QlikView

Create flags to count Unique

Fri, 20 Mar 2015 22:09:22 GMT

Hi,

Very new to QV. My data is order numbers with multiple events. I'm trying to flag when an order has both an 2 and 4 event.

Order Event

123456 6

123456 2

123456 9

123456 4

If order number 123456 has both a 2 and 4 event create flag 1 else 0.

Not able to get it to work, only able to identify if it has one or the other. Any help is very much appreciated.

Miguel_Angel_Baeyens — Sat, 21 Mar 2015 10:33:16 GMT

Hi Kerri,

Using Peek() and Previous() function should work. See sample codes in

Miguel

maxgro — Sat, 21 Mar 2015 10:56:59 GMT

source:

load * inline [

Order , Event

123456 , 6

123456 , 2

123456 , 9

123456 , 4

1,2

1,3

2,4

2,5

3,6

3,7

3,8

];

Left join (source)

load Order, if(count(Event)=2,1) as cnt

resident source

where match(Event, 2,4)

group by Order;