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

[Qlik__Vinodh]

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.

or

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

[Gysbert_Wassenaar]

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

[Qlik__Vinodh]

Hi thanks for reply,

Please find the sample qvw file.

[jagan · Accepted solution]

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.

[Qlik__Vinodh]

Hi help on this..jagan