Discussion Board for collaboration related to QlikView App Development.
Could someone please help me. As i am trying to get the firstsorted value for each dimensions and use the firstsorted value to count no of IDs.
I got Top City using First sorted value =
For example: FirstSortedValue(city_name, (-(Aggr(count(ID), Country, city_name))))
but i want to calculate the Customers at that City by using above expression, as i cant use If condition as we have many countries.
Thanks in advance.
Max(Aggr(Count(ID), Country, city_name)