topic Pivot table export to Excel number format issue in QlikView

Pivot table export to Excel number format issue

Thu, 27 Feb 2014 02:57:22 GMT

We have this pivot table that display the overall Value of each day and Value of each customer of the day.

The overall Value is a dimension so we cannot perform a sum in the report. But after export, this overall values is converted to text so our user is unable to sum them up too.

I just don't understand why this field is export as text. I had try on setup the field format at Document Properties, Convert them in the dimension and change the alignments but still no luck..... is this a bug in QV or something that I missed???

Re: Pivot table export to Excel number format issue

jagan — Thu, 27 Feb 2014 03:07:42 GMT

Hi,

Did you converted the format by using Num()?

Regards,

Jagan.

Re: Pivot table export to Excel number format issue

Thu, 27 Feb 2014 03:21:03 GMT

Yes, at dimension level....

Re: Pivot table export to Excel number format issue

Thu, 27 Feb 2014 03:24:10 GMT

I think i get it.... I have to do it at Load script level.... Is working now.... Thanks~~~