Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner - Contributor III
Partner - Contributor III

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

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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Qlik__Vinodh
Partner - Contributor III
Partner - Contributor III
Author

Hi thanks for reply,

Please find the sample qvw file.

jagan
Luminary Alumni
Luminary Alumni

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
Partner - Contributor III
Partner - Contributor III
Author

Hi help on this..jagan