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

[srikanth99]

Hi Team,

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

[md_qlikview]

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)