Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Community,
Table1:
ID, Name, Salary
100, XYZ, 2000
101, ABC, 1500
102, ADS, 2300
103, QZX, 200
104, POQ, 7500
];
can we sort the dara using FirstsortedValue ???
My OutPut should be like using FirstSortedValue:
ID, Name, Salary
104, POQ, 7500
102, ADS, 2300
100, XYZ, 2000
101, ABC, 1500
103, QZX, 200
Thanks in Advance...!!!
LIke ID
It will give you the same result as if you were going to use Name as expression instead of FirstSortedValue(Name, -Salary). It won't sort anything for you, unless you sort it on the sort tab.
FirstSortValue() from QlikView help: