topic Re: Number formatting lost in excel export in QlikView

Number formatting lost in excel export

Anonymous — Fri, 03 Jan 2014 10:42:48 GMT

Hi,

I've been looking around the communtiy for a solution of the export problem and i've seen that it WAS i bug (but not anymore i guess) and my QV is up to date with the latest release.

So here's my problem. I have expressions in my table that have conditionally set number formats accordingly. So some of the rows are in % and some in integers. In QV this looks great. But when i export it to excel, regular icon i header, (using ajax by the way), it's in text format. I can't use the number formatting in the properties since i have the conditional formatting so that is my problem.

Anyone have an idea what to do?

Thanks in advance!

//A.

Re: Number formatting lost in excel export

Fri, 03 Jan 2014 21:20:27 GMT

The only solution I've seen is nesting the expressions with num(). This way the expressions won't be exported as text. Not sure you'll keep the formatting if column was a % though, but you could try num(YourExpression, '0.00 %') for these cases.

Best,

Matt

Re: Number formatting lost in excel export

Anonymous — Tue, 07 Jan 2014 15:27:38 GMT

But that is how i have formatted the numbers in the column. Maybe i wasn't clear on that point .

I have an if statment in the expression to set the number format (num()) if it is suppose to be an integer or a %-age.

Re: Number formatting lost in excel export

vadimtsushko — Thu, 06 Feb 2014 04:30:50 GMT

Dynamic formatting of chart excpression works for us on QV11 SR4 and SR5.

We've switched to such technic in current projects.

Take a note that currently Num() formatting does not preserve by `Sent to Excel` command, but Money() formatting exports correctly

See also my post at inqlik dot github dot io /2014/01/dynamic-number-formatting-in-chart-expressions/ for more info and samples

I that do not work for you, maybe you can make a sampe qvw file with your problem, I would look, if it work in my environment normally.