topic Re: Days wise sale input box in QlikView

Days wise sale input box

prma7799 — Thu, 21 Sep 2017 12:15:51 GMT

Hi All,

I have one chart in that dimension is day([Date]) and Expressions are CM , LM & PYM

Now sometimes user want see only last 7 days data using input box.

Say suppose I have select Apr Month so it will see only last 7 days

i.e

Thanks

PrashantSangle — Thu, 21 Sep 2017 12:19:35 GMT

In your expression try below

sum({<date={">=$(=date(max(date)-7))<=$(=date(max(date)))"}>}sales)

Note: Change date format as per your date format,

replace 7 with input variable to calculate dynamically

Regards,

prma7799 — Thu, 21 Sep 2017 12:25:48 GMT

Hi Prashant,

I don't want to change the expression. I want like Top 10 analysis sometime user will inter 5 , 12 , or 30 also in input box .

Thanks