topic Re: if condition with same value in QlikView

if condition with same value

priyarane — Thu, 02 Nov 2017 11:16:25 GMT

hi Community,

I am finding the way to create 2 different attributes with same value like below.

Dim1

I am trying to create below condition based on above data(Dim1)

if(match(Dim1,'A','B','C','D'),'Cons',

if(match(Dim1,'A','B'),'AB_Cons')) as Cons_Filter

I want both to be populated Cons and 'AB_Cons' under Cons_Filter but values are filter first level itself so I am getting only 'Cons'.

Can someone please help if we have any work around to get desired values.

_priya

sunny_talwar — Thu, 02 Nov 2017 11:20:55 GMT

May be try like this

LinkTable:

LOAD 'Cons' as Cons_Filter,

Dim1

Resident Table

Where match(Dim1,'A','B','C','D');

Concatenate(LinkTable)

LOAD 'AB_Cons' as Cons_Filter,

Dim1

Resident Table

Where match(Dim1,'A','B');

priyarane — Thu, 02 Nov 2017 13:26:56 GMT

Thanks Sunny, I tried this but lot of columns I have to hard code, so do we have any other approach like by hirarchy.

sunny_talwar — Thu, 02 Nov 2017 13:30:46 GMT

Not sure I understand? You have to hard-code the values within the Match statement? But you were doing the same for your if statement also?

priyarane — Thu, 02 Nov 2017 13:49:22 GMT

it is like

under A --- ABCD

for B -- BC

For C- C

For D - DE

like that

sunny_talwar — Thu, 02 Nov 2017 13:51:11 GMT

Still not sure what you mean....