topic Re: Complex Dynamic Calculation in QlikView

Complex Dynamic Calculation

lalitinmbd — Wed, 02 Apr 2014 06:52:55 GMT

Dear All,

I have come across the requirement on which i need help. Below is the scenario

I am here by attaching an excel which contains the date wise Dealer wise Sales. I need the count of those dealers who has done sales at least 6 months in the last one year (this bracket should change as per the user selection e.g Let say user has selected 2013 feb then i need count of dealers who has done sales for at least 6 months in Feb 2012 to Jan 2013).

Any idea guys how to do this.

Thanks in Advance.

Re: Complex Dynamic Calculation

MK_QSL — Wed, 02 Apr 2014 07:27:42 GMT

Please check enclosed file...

UPDATE

If you are using my file.. you can get no of Dealers with name by writing below code in text box...

='There are : '&COUNT({<MonthID = {">=$(=Max(MonthID)-5)<=$(=Max(MonthID))"}>}Distinct Dealer) & ' Dealers : '&

CONCAT({<MonthID = {">=$(=Max(MonthID)-5)<=$(=Max(MonthID))"}>}Distinct Dealer,', ')

Re: Complex Dynamic Calculation

Wed, 02 Apr 2014 09:36:45 GMT

Hi,

Find the attached solution and let me know if it is suitable.

Thanks,

Prabhu

Re: Complex Dynamic Calculation

mahesh_agrawal — Wed, 02 Apr 2014 12:13:13 GMT

Hi Lalit,

Please find the attached .QVW file. I have used your Excelsheet as source.

I hope it answers your problem.

Re: Complex Dynamic Calculation

lalitinmbd — Mon, 07 Apr 2014 06:39:48 GMT

Thanks alot Prabhu. It worked perfectly....