Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Please post a small qlikview document with example data that we can use to show you how to do that.
Hi thanks for reply,
Please find the sample qvw file.
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.
Hi help on this..jagan