Need Help

[paulwalker]

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...!!!

[paulwalker]

LIke ID

[sunny_talwar]

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: