topic Re: Grouping in List Box in QlikView

Grouping in List Box

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a field called GroupMajorCode. Which is having values 1 to 100.

My requirement is to create a List Box. List box should show three values:

1.Core Group Major

2.Bluepoints Group Major

3. Consolidated

when GroupMajorCode <> '071', Core Group Major

when GroupMajorCode = '071', Bluepoints Group Major

when GroupMajorCode is all including '071', Consolidated.

I am using below script in my load script:

if(GroupMajorCode <> '071', 'Core Group Majors',

if(GroupMajorCode = '071', 'Bluepoints Group Majors',

if(GroupMajorCode <> '0','Consolitated'))) as GroupMajor,

but I am only getting first two, not getting consolidated.

Can anyone please help me to do the same.

Thanks for your help.

Sarif

Re: Grouping in List Box

tresB — Tue, 01 Aug 2017 08:45:13 GMT

I guess you have to use two loads like:

Load

if(GroupMajorCode <> '071', 'Core Group Majors',

if(GroupMajorCode = '071', 'Bluepoints Group Majors')) as GroupMajor

From <>;

Concatenate //This might not be needed if autoconcatenated

Load

if(GroupMajorCode <> '0','Consolitated') as GroupMajor

From <>;

Re: Grouping in List Box

sunny_talwar — Tue, 01 Aug 2017 11:31:07 GMT

I don't think this is possible directly in the list box object.... the only option I see is to do it in the script like tresesco‌ mentioned or do this in a Link Table to minimize any effect in your fact table (in case it is huge).... process of how to do it will stay the same in any case (as shown by Tresesco above)