topic group number by range in QlikView

group number by range

markgraham123 — Wed, 01 Feb 2017 18:11:55 GMT

All,

I'm trying to group Days 0,1 into group1

0,1,2 - group2

0,1,2,3 - group 3

0,1,2,3,4 - group 4

0,1,2,3,4,5 - group5

0,1,2,3,4,5,6,7,8,9,10 - group 6

0....... infinity - group7

can someone please help.

Re: group number by range

sunny_talwar — Wed, 01 Feb 2017 18:18:40 GMT

Try like this

Test:

LOAD * Inline

[

Days

];

Test2:

LOAD Days,

'Day 1' as All_Days

Resident Test

Where Days <= 1;

Concatenate(Test2)

LOAD Days,

'Day 2' as All_Days

Resident Test

Where Days <= 2;

Concatenate(Test2)

LOAD Days,

'Day 3' as All_Days

Resident Test

Where Days <= 3;

Concatenate(Test2)

LOAD Days,

'Day 4' as All_Days

Resident Test

Where Days <= 4;

Concatenate(Test2)

LOAD Days,

'Day 5' as All_Days

Resident Test

Where Days <= 5;

Concatenate(Test2)

LOAD Days,

'6-10' as All_Days

Resident Test

Where Days <= 10;

DROP Table Test;

EXIT Script

Re: group number by range

markgraham123 — Wed, 01 Feb 2017 18:19:37 GMT

So, 'if' statement would not work here right?

Re: group number by range

sunny_talwar — Wed, 01 Feb 2017 18:24:04 GMT

Don't think so...

Re: group number by range

markgraham123 — Wed, 01 Feb 2017 18:24:54 GMT

Thanks a lot sunny

Was just checking. Thanks

Re: group number by range

sunny_talwar — Wed, 01 Feb 2017 18:28:33 GMT