Discussion Board for collaboration on QlikView Scripting.
How do we remove reverse duplicates in Qlikview?
I have a table that contains rows like AB,AC,AD and BA,BC,BD.
The following is a description and solution for the problem in SQL. I am just not able to figure out how to do this in QlikView?
The problem has already been solved using scripting. Reverse Duplicates
My Question is, could we achieve the same using QlikView chart expressions?
Handling this in set analysis is very difficult what I can suggest is arrive a flag in script and then use set analysis to exclude the duplicates, try like below
LOAD *,Ord(Pos1) + Ord(Pos2) as Value;
LOAD * Inline [
If(Peek(Value) <> Value, 0, 1) AS IsDuplicate
ORDER BY Value;
DROP TABLE Temp;
Now in chart try below expressions
Hope this helps you.