Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

When we click on date in multibox how to get the last 7 days sales percentage in text Object

Hi Team,

                When we select date last seven days data should be displayed in the text object

Capture.PNG

2 Replies
Highlighted
Creator II
Creator II

Re: When we click on date in multibox how to get the last 7 days sales percentage in text Object

Hi,

Try using below expression

=num( Sum({<Date={">=$(=(Max(Date)-7))<=$(=Max(Date))"}>}Sales)

/

Sum({<Date=>} TOTAL Sales) , '##,###%')

Also, if needed check the date format and give appropriate format to date field

using Date function eg. Date(Date , ' DD/MM/YYYY)

Highlighted

Re: When we click on date in multibox how to get the last 7 days sales percentage in text Object

= Sum({<SaleDate={">=$(=(Max(SaleDate)-7))<=$(=Max(SaleDate))"}>}Sales)          /

          Sum(TOTAL SaleDate, Sales)