topic Re: Need Help in QlikView

Need Help

paulwalker — Wed, 12 Aug 2015 05:47:15 GMT

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

Re: Need Help

sunny_talwar — Wed, 12 Aug 2015 05:48:59 GMT

Sort the data in the script or front end object???

I don't think you need FirstSortedValue() for this

Re: Need Help

kkkumar82 — Wed, 12 Aug 2015 05:55:22 GMT

Hi,

if you want it in the UI , goto sort option in the properties and select by expression and write the expression as sum(Salary) and order as Descending.

Thanks

Kiran Kumar

Re: Need Help

sunny_talwar — Wed, 12 Aug 2015 05:56:00 GMT

In a table box object you can do this:

Re: Need Help

Wed, 12 Aug 2015 05:58:14 GMT

ID,

Name,

Salary

Resident ABC Order by Salary DESC;

Thanks

Manju

Re: Need Help

paulwalker — Wed, 12 Aug 2015 05:58:43 GMT

HI Sunny,

I know that front end options,

is it possible to sort using FirstSortedValue???

Re: Need Help

sunny_talwar — Wed, 12 Aug 2015 06:01:16 GMT

FirstSortedValue is a function used to find sorted value and not used for sorting itself. May be if you mention your requirement, we might be able to help you better.

Are you trying to sort in the front end or back end?

Re: Need Help

jsingh71 — Wed, 12 Aug 2015 06:06:00 GMT

Use This:

Temp:

Load * Inline [

ID, Name, Salary

100, XYZ, 2000

101, ABC, 1500

102, ADS, 2300

103, QZX, 200

104, POQ, 7500

];

Table1:

LOAD Salary

,Name

Resident Temp

Order By Salary desc,Name;

Drop Table Temp;

Output will be:

Re: Need Help

paulwalker — Wed, 12 Aug 2015 06:12:27 GMT

Yeah Sunny,

I know how to sort..

Acutally i thought FirstSortedValue sorting the data.

IF am use this script or Expression side FirstSortedValue(Name, -Salary).

then waht will happen ??

Re: Need Help

sunny_talwar — Wed, 12 Aug 2015 06:14:50 GMT

What is your chart's dimension?

Re: Need Help

paulwalker — Wed, 12 Aug 2015 06:19:48 GMT

LIke ID

Re: Need Help

sunny_talwar — Wed, 12 Aug 2015 06:24:58 GMT

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: