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

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

srikanth99 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

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

md_qlikview — Sun, 29 Jul 2018 09:36:35 GMT

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)

BalaBhaskar_Qlik — Sun, 29 Jul 2018 14:22:18 GMT

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

Sum(TOTAL SaleDate, Sales)