topic Re: Exporting a Pivot as a Pivot to Excel in QlikView

Exporting a Pivot as a Pivot to Excel

suraj_qlikdev — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

As per the requirement I need to replicate Qlikview pivot table exactly the same way how it appears on Qlikview in to excel.

I tried right click on pivot > Copy to clipboard > Copy full table and pasted on to excel. This way the pivot appears exact same way how it appears on Qlikview but I do not see the comma's. I tried number format, expression default, integer it did not work.

Is this a bug or is there a workaround for this?

It works fine with Money format ($#,##0.00;($#,##0.00)) but I want in this other formats.

I am attaching the qvw for reference. Thanks in advance!

Thanks,

Suraj

jagan‌ mto‌

Re: Exporting a Pivot as a Pivot to Excel

ElizaF — Wed, 28 Dec 2016 20:07:59 GMT

Hi,

Find some help with the link below:

https://community.qlik.com/message/261296?&_ga=1.207808529.2009395876.1474883438#261296

An alternative solution, is to use the Text() Function like this:

Text(Num(Sum(TeamExpenses), '#,##0.00') )

When sending to Excel, it will treat your values as text and therefore will keep the format you need.

Hope it helps,

Eliza

Re: Exporting a Pivot as a Pivot to Excel

suraj_qlikdev — Wed, 28 Dec 2016 20:41:19 GMT

Works perfect!! Thank you so much.

Re: Exporting a Pivot as a Pivot to Excel

ElizaF — Wed, 28 Dec 2016 20:53:33 GMT

My pleasure! Question: What Qlik View version you use?

Re: Exporting a Pivot as a Pivot to Excel

suraj_qlikdev — Thu, 29 Dec 2016 02:17:15 GMT

Qlikview 11.2 SR 12