Discussion Board for collaboration on QlikView Scripting.
Hi, I was trying to do a nested if statement,
Where if the filed "Name"is null and "Filter count" >1 then i wanna display the field "Dept"
Can some pls look into this.
If(Len(Trim(Name))=0,Dept, If([Filter Count] > 1, Dept, [Name])) as [New Column],
Solved! Go to Solution.
Filter count is the filed, where i'm checking in the script, if the ID has more than one Name.
If so, we wcannot display the same in the straight table with two values , so we will take Dept. instead of Name.
This trick works in the user interface.
If you need this in a Straight Table, you can simply use aggregation as the dimensions of the straight table will do the group-by anyway.