Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

How to export the number(Show percentage) into excel

Hi All,

When I export the figures with percentage into Excel, it is shown as numberic format not percentage, how to handle it?

For example: if the figure is 10%, it is shown as 0.1 in Excel.

1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Re: How to export the number(Show percentage) into excel

Hi,

It work for me. Let check my attached file.

Hope it help.

Regards,

Sokkorn

7 Replies
afuchten
Valued Contributor

How to export the number(Show percentage) into excel

In which point in the application the data is converted to a percentage?

Is this done on the front-side in the graph using the formatting percentage?

Sokkorn
Honored Contributor

How to export the number(Show percentage) into excel

Hi,

Add text function: TEXT(PercentageField)

Regards,

Sokkorn

afuchten
Valued Contributor

How to export the number(Show percentage) into excel

text(precentagefield) makes a textfield of the precentage value ... it depends if it is a problem the excel field is a textfield instead of a numeric field 😉

Not applicable

How to export the number(Show percentage) into excel

Thanks, but when I use text function, that figures align to left not right in Excel,  even if it aligns to right in QV.

How to solve it?

Sokkorn
Honored Contributor

Re: How to export the number(Show percentage) into excel

Hi,

Suppose that your expression (%) like this: (COLUMN(1) - COLUMN(2))/COLUMN(2)

Goto Number tab ==> Select on expression ==> choose Interger with format #,##0.00 and check on "Show in Percent(%)".

Let me know if this help you.

Regards,

Sokkorn

Not applicable

Re: How to export the number(Show percentage) into excel

But if I use your expression, when I export it into Excel, it is shown as numberic format not %...

Sokkorn
Honored Contributor

Re: How to export the number(Show percentage) into excel

Hi,

It work for me. Let check my attached file.

Hope it help.

Regards,

Sokkorn