Discussion Board for collaboration related to Creating Analytics for QlikView.
I want to create a function to calculate the days with the highest occupancy. Till now I have
FirstSortedValue(Datum,-Aggr(sum(Occupancy),Contract)). But when there are mutliple dates with the highest occupancy this function doesn't work. How to solve this?
Go to Solution.
Your expression looks good just replace
Thanks for the quick answers but.....
That is just an error shown by the expression editor. Click ok and you should be able to see the result.
you are correct, thanks for helping
This is just to scare you, but it works. QlikView sometimes play with us.
Just curious to know.. What's the reason for not selecting my answer as correct !!!!
Happens to me all the time
My answer was 2 mins earlier than selected answer...
I can understand if the answer was something different than my one.!!!
It's OK.. We shouldn't try to understand everyone here... Just try our best to help them out...!!