Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
srikanth99
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
md_qlikview
Creator II
Creator II

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)

balabhaskarqlik

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

          Sum(TOTAL SaleDate, Sales)