topic Calculated Dimensions Not retaining its format when downloaded in excel in QlikView

Calculated Dimensions Not retaining its format when downloaded in excel

Ankhi — Fri, 15 Nov 2024 23:34:05 GMT

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

Re: Calculated Dimensions Not retaining its format when downloaded in excel

Chanty4u — Wed, 25 Nov 2020 12:55:46 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,

Re: Calculated Dimensions Not retaining its format when downloaded in excel

Ankhi — Wed, 25 Nov 2020 13:14:12 GMT

Hi Chanty4u

Thanks for the reply.

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

Re: Calculated Dimensions Not retaining its format when downloaded in excel

Chanty4u — Wed, 25 Nov 2020 13:20:21 GMT

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".