topic Re: Urgent AGGR Help Needed.Please in QlikView

Urgent AGGR Help Needed.Please

Anonymous — Fri, 01 Aug 2014 12:33:51 GMT

Hi,

I am using following AGGR Function

MAX(Aggr(Sum(SALES_IM_QTY),DWH_SKU_REF_NO,DWH_IM_MONTH))

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.

I tried

FirstSortedValue(DWH_IM_MONTH,-Aggr(Sum(SALES_IM_QTY),DWH_IM_MONTH, DWH_SKU_REF_NO))

but still not.

Please if any of you experts can Help me I will be very thankful to you.

Re: Urgent AGGR Help Needed.Please

sujeetsingh — Fri, 01 Aug 2014 12:36:45 GMT

You can use if statement to compare the month with sum of every month through set analysis.

Re: Urgent AGGR Help Needed.Please

avinashelite — Fri, 01 Aug 2014 12:37:31 GMT

Hi Muhammad,

Sorry i did not get your question can u please elaborate...or post your app

Re: Re: Urgent AGGR Help Needed.Please

Anonymous — Fri, 01 Aug 2014 14:23:47 GMT

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.

Re: Re: Urgent AGGR Help Needed.Please

Anonymous — Fri, 01 Aug 2014 14:24:44 GMT

CAN YOU WRITE THE FORMULA PLEASE

Re: Urgent AGGR Help Needed.Please

simenkg — Fri, 01 Aug 2014 21:31:02 GMT

FirstSortedValue(DWH_IM_MONTH,-Sum(SALES_IM_QTY))

Re: Urgent AGGR Help Needed.Please

jaimeaguilar — Fri, 01 Aug 2014 21:52:42 GMT

Hi,

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,

regards

Re: Urgent AGGR Help Needed.Please

Anonymous — Tue, 05 Aug 2014 11:56:41 GMT

THANKS BUT ACTUALLY THIS IS WHAT I WAS THINKING THE TABLE WILL BE CREATED IN AGGR FUNCTION.