topic Re: Customers Not having the sales past 52 weeks but having the sales current week in QlikView

Customers Not having the sales past 52 weeks but having the sales current week

Qlik__Vinodh — Thu, 19 May 2016 08:18:03 GMT

Hi ,

I have a requirement like

Customers Not having the sales past 52 weeks but having the sales in Current week, those customers names list i have to display in straight table.

Customers not having the sales past 2 months but having the sales in Current month, those customers names list i have to display in straight table.

can some one help me to write the above requirement......

please find the qvw file or use the source file

Thanks,

vind

Re: Customers Not having the sales past 52 weeks but having the sales current week

Gysbert_Wassenaar — Thu, 19 May 2016 08:29:00 GMT

Please post a small qlikview document with example data that we can use to show you how to do that.

Re: Customers Not having the sales past 52 weeks but having the sales current week

Qlik__Vinodh — Thu, 19 May 2016 09:25:45 GMT

Hi thanks for reply,

Please find the sample qvw file.

Re: Customers Not having the sales past 52 weeks but having the sales current week

jagan — Thu, 19 May 2016 11:22:35 GMT

Hi,

Please find attached file for solution. Try this expression

=Sum({<Year=, Quarter=, Week=, Month=, Month_Year=, Week=, OrderDate={'>=$(=MonthStart(Max(OrderDate)))<=$(=MonthEnd(Max(OrderDate)))'}, Customer=E({<Year=, Quarter=, Week=, Month=, Month_Year=, Week=,

OrderDate={'>=$(=MonthStart(Max(OrderDate), -2))<=$(=MonthEnd(Max(OrderDate), -1))'}>})>} Sales)

Regards,

jagan.

Re: Customers Not having the sales past 52 weeks but having the sales current week

Qlik__Vinodh — Thu, 19 May 2016 11:34:40 GMT

Hi help on this..jagan