Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III


Hi everybody!

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


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

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



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.