Discussion Board for collaboration related to QlikView App Development.
I am using following AGGR Function
to find the amount of Sales in selected month and it gives me the result alright.
But if I want an expression which can also tell me the month it has taken in all the selected months i am not able to get it.
but still not.
Please if any of you experts can Help me I will be very thankful to you.
Thanks for your interest mate,
Well What I am looking is to have Maximum selling month of the selected period.
DWH_IM_MONTH | SALES_IM_QTY
May | 2300
June | 5000
July | 2000
Where June is a Max selling month.
how about this:
Max(Aggr(Sum(SALES_IM_QTY), DWH_IM_MONTH. DWH_IM_YEAR))
I suppose there's a field called DWH_IM_YEAR in your data model or maybe if you have a field with the concatenation of Month and Year, then it would be better. The thing is that you need to aggregate your sales per month and per year (maybe also by DWH_SKU_REF_NO) and then you can get the max value,