Dynamic last 15 days

[#1]

Hello,

I have a line chart where i have:

Date as dimension

Expression as:

=sum({<Date_Clean={'$(vLast15Days)'}>} TotalPrice)

This gives me from today and 15 days back.

What if i want to make this dynamic, so if i select the 27 of august, it shows me 27 of august and 15days back.

Now its just static and i cannot select a date back in time.

I have these listboxed to choose:

Month, Year, Day

[#2]

Thanks, but thats not i am looking for - Thank you for the effort!

[#3]

this is the closest we get i think - But can you answer me one thing.

Why does it not work with Date_Clean when it works with Dato?

Dato is the string date

and date_Clean is the numeric.

Shouldnt it be the same?

[MEllinghausen]

It works with Date_Clean too.

You must set =sum({<Date_Clean={">=$(vStartDay)<=$(vDato)"},Day=,Year=,Month=,Dato=>} TotalPrice)

And the variable as numeric

Von: thomas jensen

Gesendet: Dienstag, 3. September 2013 10:40

An: Ellinghausen, Marcus

Betreff: Re: – Re: Re: Dynamic last 15 days

QlikCommunity<http://community.qlik.com/>

Re: Re: Dynamic last 15 days

Antwort von thomas jensen<http://community.qlik.com/people/TJETJETJE?et=watches.email.thread> in Layout & Visualizations - Komplette Diskussion anzeigen<http://community.qlik.com/message/386197?et=watches.email.thread#386197>

[#5]

WTF? this is getting more and more strange! hah - it does not work here!

Do we agree on

the variable should be

=(Date_Clean)

and =(Date_Clean)-15

[MEllinghausen · Accepted solution]

Yes, and today = num(date(today())

[#7]

thanks, but i think i will use the first example u posted. Caause the one with the button does not work correctly. When i select a date it does not filter on that date

[er_mohit]

Try this

sum({<Dato={">=$(=Date(Max(Dato)-15))<=$(=Date(Max(Dato)))"},Day=,Month=,Year=>} TotalPrice)

[#9]

nope 😕