topic Re: Export to excel in QlikView

Export to excel

MayilVahanan — Thu, 12 Sep 2013 18:57:09 GMT

Can you please suggest its bug or not.

While export to excel the pivot/straight table, number is converted to text format in dimension.

In attached file, am using aggr() function in dimension.

Edit:

Please find the attached file

Re: Export to excel

Gysbert_Wassenaar — Thu, 12 Sep 2013 19:13:37 GMT

Looks like a bug to me. Afaict a calculated dimension is always converted to text.

Re: Export to excel

MayilVahanan — Thu, 12 Sep 2013 19:20:50 GMT

So we can't able to modify it as number format in dimension level using aggr function?

Re: Export to excel

Thu, 12 Sep 2013 19:22:06 GMT

i think this is not a bug, because when you export a pie chart , bar chart or any other type chart, the image of chart will be converted to text format in excel

Re: Export to excel

Gysbert_Wassenaar — Thu, 12 Sep 2013 19:23:16 GMT

I don't think so. You'll need to either fix the format in Excel or use a macro to export to excel and also fix the format in the macro.

Re: Export to excel

MayilVahanan — Thu, 12 Sep 2013 19:25:19 GMT

Hi lssosorio

Yes i agree tat, but actually its a number format. but how its convert the number to text format, is there any reason?

Re: Export to excel

MayilVahanan — Thu, 12 Sep 2013 19:26:45 GMT

We can go with macro, but its not work in access point except internet explorer?

Edit:

Fix the format in Excel -> its manual work, am correct?

Re: Export to excel

Gysbert_Wassenaar — Thu, 12 Sep 2013 19:31:20 GMT

Yes, manual work. Unless you create a VBA macro in Excel to do it, but that's complicated.

Re: Export to excel

Thu, 12 Sep 2013 19:39:58 GMT

I cant imagine any reason for this, but if you click with right button, copy to clipboard -> Object , open the excel and then CTRL+V , after this, you can be able to alter the values.

Re: Export to excel

MayilVahanan — Thu, 12 Sep 2013 19:55:01 GMT

Hi Leonardo Osorio and G Wassenaar

Thanks for your reply folks.

Re: Export to excel

Anonymous — Tue, 29 Apr 2014 13:06:36 GMT

Hi Mayil Vahanan Ramasamy ,

This will surely help you,

Excel exports field with value 00149E5 as 00149... | Qlik Community

Regards,

Srikumar.c