topic Re: Pivot table export to excel in QlikView

Pivot table export to excel

jordan231 — Wed, 27 Aug 2014 07:26:48 GMT

Dears, I have a pivot table with number of dimmension fields. When i export numeric data into excel they turn into text format. Expresions keep the proper format. I tried to use round and num functions without success also seetings in sheet properties are correct. Does anyone has any idea ? Thanks for any hints.

Re: Pivot table export to excel

ashfaq_haseeb — Wed, 27 Aug 2014 07:29:07 GMT

Hi,

Right click on pivot table --> Properties --> Number --> Select your Expression --> and select numbers

Regards

ASHFAQ

Re: Pivot table export to excel

jordan231 — Wed, 27 Aug 2014 07:43:52 GMT

In pivot properties you can only change settings for Expressions i'm trying to handle Dimmension settings.

Re: Pivot table export to excel

ashfaq_haseeb — Wed, 27 Aug 2014 07:48:49 GMT

Attach sample qvw with data please and scenerio

Regards

ASHFAQ