topic Re: Counter in QlikView

Counter

Fri, 24 Apr 2015 10:24:47 GMT

Hi,

I have the below table

KEY flag Day

1A 1 0

1A 0 1

1A 1 2

2A 0 0

2A 1 1

3A 0 0

3A 0 1

i need to generate another table with the KEY and a counter which indicates the number of 1's between 0 to n Day

KEY Counter

1A 2

2A 1

3A 0

Please help me with the logic

Re: Counter

marcus_sommer — Fri, 24 Apr 2015 10:35:12 GMT

Try this:

Counter:

Load KEY, sum(flag) as Counter Resident table Group by KEY;

- Marcus

Re: Counter

buzzy996 — Fri, 24 Apr 2015 10:38:17 GMT

tab3:

load * inline [

KEY, flag, Day

1A , 1 , 0

1A , 0 , 1

1A , 1 , 2

2A , 0 , 0

2A , 1 , 1

3A , 0 , 0

3A , 0 , 1

];

tab5:

load

KEY,

count(flag) as count

resident tab3

group by KEY;

Re: Counter

Fri, 24 Apr 2015 10:48:34 GMT

Thanks Marcus,

Suppose if there are more number of days and how can we find if Flag is 1 in once in 3 days?

Hoping for a solution

Re: Counter

marcus_sommer — Fri, 24 Apr 2015 10:58:19 GMT

I don't know how the flag is created. Maybe you could change these logic or you could load these table additionally with a where-clause:

Load Key, flag as 1_flag Resident result where flag = 1;

It will be depend in which situations you want what to do.

- Marcus