topic date shown as text when exporting to excel in QlikView

date shown as text when exporting to excel

Anonymous — Tue, 09 Feb 2016 00:08:44 GMT

Hi all,

Can anyone help me with this? In the straight table, I have 3 date fields, NRAS_AFAR, NRAS Y4, NRAS Y7.

NRAS_AFAR is a data field, while NRAS Y4 and NRAS Y7 are both calculated dimensions:

The NRAS Y4 calculated dimension is =Date#(AddYears(NRAS_AFAR_Value,4)) .

The NRAS Y7 calculated dimension is =Date#(AddYears(NRAS_AFAR_Value,7)) .

My question is when I exported table into excel, format of NRAS Y4 and NRAS Y7 were Text instead of DATE ('D/MM/YYYY') as I want.

what can I do to make both calculated dimensions shows as DATE format when exported to excel??

Thanks

Re: date shown as text when exporting to excel

sunny_talwar — Tue, 09 Feb 2016 01:28:36 GMT

May be wrap it around with the date function and see if that helps:

The NRAS Y4 calculated dimension is =Date(Date#(AddYears(NRAS_AFAR_Value,4)))

The NRAS Y7 calculated dimension is =Date(Date#(AddYears(NRAS_AFAR_Value,7)))

Re: date shown as text when exporting to excel

swuehl — Tue, 09 Feb 2016 01:30:22 GMT

Instead of the calculated dimension, you can use expressions (which will be exported with a correct date format to excel). You can use the same expression as used in the calculated dimension, since your data is grouped by NRAS_AFAR_Value.

Drag the expressions to the left if you want to keep the original layout.

Re: date shown as text when exporting to excel

Anonymous — Tue, 09 Feb 2016 02:31:01 GMT

Thanks swuehl,

I tried and it worked. You are right. Use expression is easier to handle the date format thing.

Really appreciate your help.

Re: date shown as text when exporting to excel

Anonymous — Tue, 09 Feb 2016 02:32:53 GMT

Thanks for the reply.

I have no idea why calculated dimension can not exported as date format. But I use expressions instead, and it worked.