Discussion Board for collaboration related to QlikView App Development.
I have a case . There is an hiearchy table in my app . I would like write if statement in a straight table.
In my table below, I will add new calculate dimension.
My script like ;
At then end I would like to get this result (red one)
my script would like ; for ABC.1 row
if (one condition satisfies , match(up,level_explanation) ) // I dont know which function is used here.
I would like to get one up level's level explanation.
Thanks in advance.
Go to Solution.
A small change in script will get you desired result with no hassle.
Try below script;
Load Level,UP,ID,Level_Explanation From XYZ;
Left join (Data)
Load ID as UP,Level_Explanation as UP_Level_Explanation From XYZ;
Use peek() in your script,
if(condition,peek(mySale)) as expectedOutputFROM --------