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]

does not work 😕

[MEllinghausen]

Hallo Thomas,

please look to the attached file

Marcus

[Clever_Anjos]

Object type Calendar/Slider

[#5]

I see your point, but when i make a variable called date = Date_clean my inputbox just shows an -

But when i make the same variable in my QVD load, it works fine?

[MayilVahanan]

Hi

Try like this

DateFormat must be same.

=sum({<Date_Clean={">=$(=Date(Max(Date_Clean)-15,'YYYY-MM-DD'))<=$(=Date(Max(Date_Clean),'YYYY-MM-DD'))}>} TotalPrice)

[#7]

My date format is the same:

In my main script it is YYYY-MM-DD

My Date_Clean dates are YYYY-MM-DD

converted to num(Date_Clean) So they are numeric

[#8]

heres how my dates look like:

[#9]

Are u able to make it so it start with this day and 15 back, and then when i select a date it goes 15days back from that date, cause now it shows all values untill u select a date

[#10]

The other strange thing is:

In my QVDload - where i load from QVD files, i can do it and i can even make a variable called vDate = Date_Clean

which gives me a number, but when i does it in my BINARY load qvw nothing happens

[MayilVahanan]

Hi

Can you provide a sample file?