Discussion Board for collaboration on QlikView Layout & Visualizations.
LOAD * INLINE [
sum(Fact)/sum(Plan) as Result
Resident Plan Group by Channel;
Drop Table Plan;
I need get value in Text object from a 'Channel' field with the maximum result.
In this case must be "Wholesale"
If possible please add it to the file.
Go to Solution.
May be this
=FirstSortedValue(Channel, -Aggr(sum(Fact)/sum(Plan), Channel))
It works fine.
But I missed something.
Result calculation is in Variable
vResult = sum(Fact)/sum(Plan)
Below variant doesn't work.