topic Re: How to use date functions? in QlikView

How to use date functions?

Fri, 11 Jul 2014 07:50:28 GMT

Hi there,

if I want to capture last year or last month or last week or last 10 days result, how to use data functions in script?

thank you in advance!

Re: How to use date functions?

tresB — Fri, 11 Jul 2014 07:57:39 GMT

Perhaps you have to make it a bit more clear about your requirement.

Re: How to use date functions?

stevedark — Fri, 11 Jul 2014 08:09:03 GMT

Your best bet is probably Set Analysis, something like:

=sum({<MyDate={">=$(=MonthStart(AddMonths(max(MyDate), -1)))"}>}MyValue)

=sum({<MyDate={">=$(=Date(max(MyDate) - 10))"}>}MyValue)

But, point in time reporting, especially matching dates in Set Analysis can be slightly tricky, so I would suggest looking at a few examples. This is one I have put together that you may find useful:

QlikView App: Set Analysis - Prior Period Comparison

Cheers,

Steve

Re: How to use date functions?

its_anandrjs — Fri, 11 Jul 2014 08:15:24 GMT

You have to go for SET analysis or you can use the variables with the data functions for obtain the last date values.