Change over Time

[#1]

Hi,

Is there a way to show change over time by referencing specific dates? For example how would I write an expression to show the change in count from Last Week to Today?  I'm looking for a generic formula that translates as days change, so just just specific dates.

Thank you!

[maxgro]

something like that (count today of expr1 minus one week ago; there isn't any reference to specific date, it will works tomorrow and so on....)?

d is a date field

=count ({$<d={"$(=date(Today()-0))"}>} Expression1) - count ({$<d={"$(=date(Today()-7))"}>} Expression1)

[#3]

I'm looking more along the lines of establishing the difference between a Max Date and a Min Date.  I do not load the data every day, so there is not always a today() for my date field.  And then the Min Date would be the earliest date in my date field.

[maxgro · Accepted solution]

you can use min and max of your date (d) field

=Sum( {$<d={"$(=max(d))"}>} Expression1)

or flag some specific days in a master calendar (a lot on post about that) http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd)

to simplify set analysis