Discussion Board for collaboration on QlikView Scripting.
I am finding the way to create 2 different attributes with same value like below.
I am trying to create below condition based on above data(Dim1)
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.
May be try like this
LOAD 'Cons' as Cons_Filter,
LOAD 'AB_Cons' as Cons_Filter,
Thanks Sunny, I tried this but lot of columns I have to hard code, so do we have any other approach like by hirarchy.
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?
it is like
under A --- ABCD
for B -- BC
For C- C
For D - DE
Still not sure what you mean....