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?
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.
This is just to scare you, but it works. QlikView sometimes play with us.
you are correct, thanks for helping
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...!!
Neki kar aur dariya mein daal Manish Bhai
The same happened with kushal chawda
Filter multiple values in script
I agree with you and this happens to me also... But it is a satisfaction that we get when we help others in need.
Retrieving data ...