topic Re: current date minus 7 days in QlikView

current date minus 7 days

Thu, 14 May 2015 17:04:05 GMT

Hi all!

I am struggling with such expression (percentage of rate's changing between 7 days):

1- Avg(index_1)/Avg({1<date = {'current date minus 7 days'}>}index_1)

Could you help me!?

Thanks! Marina

Gysbert_Wassenaar — Thu, 14 May 2015 17:06:55 GMT

1- Avg(index_1)/Avg({1<date = {"$(=today()-7)"}>}index_1)

It's possible you need to set the date format too. If the date format of your date field is MM/DD/YYYY then you can try:

1- Avg(index_1)/Avg({1<date = {"$(=date(today()-7,'MM/DD/YYYY'))"}>}index_1)

Thu, 14 May 2015 17:19:53 GMT

O, thanks a lot, and how to transform this expression if I need "current by selected date - 7", not exactly "today")) .

Gysbert_Wassenaar — Thu, 14 May 2015 17:25:53 GMT

date={"$(=max(date)-7)"}

Anonymous — Thu, 14 May 2015 17:28:23 GMT

Still, it is more reliable with date():

date={"$(=date(max(date)-7))"}

manojkulkarni — Thu, 14 May 2015 17:46:47 GMT

Set vSelDateMinus7 =date(max(date)-7)

1- Avg(index_1)/Avg({1<date = {'$(vSelDateMinus7 )'}>}index_1)

Thu, 14 May 2015 18:25:33 GMT

all these expressions doesnt work ( I try to use it in text box..

even Avg({1<date = {"$(= makedate(2015,4,30))"}>}index_1) doesnt show anything

What have I missed?

Anonymous — Thu, 14 May 2015 18:53:37 GMT

Looks fine... Are the field names correct? What if you use this:

avg({1<date = {'30/04/2015'}>}index_1)

(I assume that your date format is DD/MM/YYYY. Make corrections in the set if it is different)

Fri, 15 May 2015 10:19:22 GMT

Thank u very much!!! Ive done it!! there was a problem with data format~!