Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Question FIRSTSORTEDVALUE

Hi everybody!

I've the following Problem with this code i select the last Production Price.

=FIRSTSORTEDVALUE(KalkHerstellkosten,-Kalkdat)

It works but now i have the Problem that Kalkdat has this values

13.11.2019 16:59:03       Price 4091

13.11.2019 16:59:03       Price 5000

My Result is NULL, how i can solve this Problem? How can i make it that the higher Value 5000 will be the result?

 

Thank you very much!

 

Labels (1)
2 Replies
Highlighted

Returns NULL because there is not a single value for Kalkdat, both timestamps look identical. Use a Max(Price) GROUP BY Date instead, or equivalent Aggr() function if it's on a chart. Or allow more precision in the timestamp, although that could result in a long, heavy field.
Highlighted
Digital Support
Digital Support

Roland, just wanted to provide the Help link for the function, so you can check all the specifics there to be sure you have things correct, but Miguel is correct, if this answered your question, do not forget to use the Accept as Solution button to mark things for other Community Members and to give credit to the poster for the help...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.