topic Re: Firstsortedvalue issue in QlikView

Firstsortedvalue issue

kkkumar82 — Sun, 17 Jun 2018 08:54:31 GMT

I want to know the Student who got the minimum mark.

I was able to get expression to get the minimum mark for each subject but I was trying to get expression who is the student who secured this but my firstsortedvalue expression is not returning this.

PFA a file where I am trying this.

Re: Firstsortedvalue issue

Or — Sun, 17 Jun 2018 09:03:48 GMT

Assuming you want to add this to the list of subjects:

FirstSortedValue(Student,Marks)

Re: Firstsortedvalue issue

kkkumar82 — Sun, 17 Jun 2018 13:02:32 GMT

The way you gave is correct but I want it in the pivot table which I am trying

Re: Firstsortedvalue issue

mikaelsc — Sun, 17 Jun 2018 13:31:02 GMT

FirstSortedValue(Student,aggr(-sum(Marks),Student,Subject))

Re: Firstsortedvalue issue

arvind1494 — Sun, 17 Jun 2018 14:39:24 GMT

FirstSortedValue(Student,-aggr(min(Marks),Student)

Re: Firstsortedvalue issue

kkkumar82 — Mon, 18 Jun 2018 02:28:35 GMT

This is not working its returning only values for some of the rows

Re: Firstsortedvalue issue

kkkumar82 — Mon, 18 Jun 2018 02:29:24 GMT

Hi Sunny,

Can you please look into this.

stalwar1‌

Re: Firstsortedvalue issue

sunny_talwar — Mon, 18 Jun 2018 02:39:33 GMT

Try this

Firstsortedvalue(Total <Subject> Student, Aggr(Sum(Marks), Student, Subject))