Calculated Dimensions Not retaining its format when downloaded in excel

[Ankhi]

Hi All,

I have 3 calculated dimensions one date and two numbers. They are working fine in the report. But when the user is downloading the report in excel, although the data is fine but the format is not being retained in excel. Can any one please help on how to fix this. 

Sample expression used in the dimension is below

=if(match([TS],'AP','EV'),Null(),Date([PR Date],'DD-MMM-YY'))

=if(match([TS],'AP','EV'),Null(),[Purchase Order Number])

Regards

Ankhi

[Chanty4u]

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, 

[Ankhi]

Hi Chanty4u

Thanks for the reply.

I tried using the same calculations in expression but it is messing up my data .. 😞

[Chanty4u]

try this

In Qlik menu Settings/Document Properties/Number on the left column select the field and then specify "Number format setting" as Date and set the "Format pattern".