topic Re: Re: First Sorted Value in Qlik Learning Discussions

First Sorted Value

nikhilgarg — Fri, 22 Aug 2014 05:39:48 GMT

I want to find out Customer name corresponding to lowest unit price. I am using following syntax but an error is showing. Can anyone tell me the correct solution ??

FirstSortedValue(Customer,Min(UnitPrice))

Re: First Sorted Value

jonathandienst — Fri, 22 Aug 2014 05:55:10 GMT

Usually, that should be:

FirstSortedValue(Customer, UnitPrice)

HTH

Jonathan

Re: First Sorted Value

nikhilgarg — Fri, 22 Aug 2014 06:02:54 GMT

HEy,

Still it is not working and i want Customer with minimum UnitPrice then i think min() should be used , right ??

Re: First Sorted Value

jonathandienst — Fri, 22 Aug 2014 06:24:41 GMT

No, FirstSortedValue will find the min for you. But if that is not working, then you need to post a sample of your model so that we can looks at the why its not working (data structure or sheet object related)

You may need to do this in the load script if you have items with null or zero UnitPrice, or many items with the same (minimum) unit price. Or perhaps this works:

FirstSortedValue(Customer, Aggr(Min(UnitPrice), Customer))

HTH

Jonathan

Re: First Sorted Value

nikhilgarg — Fri, 22 Aug 2014 06:29:01 GMT

HEy,

I ahve attached the qvw file , so kindly see it and let me know..

Re: Re: First Sorted Value

jonathandienst — Fri, 22 Aug 2014 06:37:37 GMT

Not sure what you are trying to achieve - as you have Customer and UnitPrice as dimensions in your chart, there is no purpose to the FirstSortedValue.

I have added a straight table using product and finding the customer with the lowest unit price for the product.

HTH

Jonathan

Re: Re: First Sorted Value

nikhilgarg — Thu, 28 Aug 2014 06:53:44 GMT

WHile using QVSource, I used linkedin connector and loggedin with a id. It gets authenticated but no data is shown. I dont know what to do. Please tell me how it works. I am using free version of QVSource.