topic Re: Calculated Date Dimension in QlikView

Calculated Date Dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to create a calculated dimension that returns a date in a straight table chart. There is a dimension already called finish date and I would like to calculate a date 60 days prior to that finish date. Can anyone advise me please?

Re: Calculated Date Dimension

oknotsen — Thu, 05 May 2016 14:44:13 GMT

Hi,

dateField - 60.

Yes, that easy.

You might need to reform the result back to date, so maybe date(dateField - 60).

Re: Calculated Date Dimension

ziadm — Thu, 05 May 2016 15:16:14 GMT

I would suggest creating a new data dimension on the load script and do not use the calculated dim for performance issues

Load *,

(finish date - 60) as NewDate

This NewDate is you Dimension

Re: Calculated Date Dimension

Thu, 05 May 2016 15:50:49 GMT

date(num(datefield)-60) as newfield

Re: Calculated Date Dimension

Anonymous — Thu, 05 May 2016 22:20:15 GMT

That worked, thanks a lot.

Re: Calculated Date Dimension

oknotsen — Fri, 06 May 2016 20:08:44 GMT

Happy I could help.

Please note that from a performance point of view, I would advise to add this value as a field to your data model instead of using a calculated dimension.

Enjoy!