Exporting a Pivot as a Pivot to Excel

[suraj_qlikdev]

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‌

[ElizaF · Accepted solution]

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

[suraj_qlikdev]

Works perfect!! Thank you so much.

[ElizaF]

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

[suraj_qlikdev]

Qlikview 11.2 SR 12