topic Re: Change over Time in QlikView

Change over Time

Tue, 06 May 2014 16:25:21 GMT

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!

Re: Change over Time

maxgro — Tue, 06 May 2014 19:54:41 GMT

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)

Re: Change over Time

Tue, 06 May 2014 20:19:42 GMT

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.

Re: Change over Time

maxgro — Tue, 06 May 2014 20:39:05 GMT

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