Exporting to excel as number

[Anonymous]

Hi!

I have a teble with an expression containing two different number formattings (created as variables) depending on the value in the dimension. Expressions looks something like this:

=if(something,num(expression1,vNumberFormat),num(expression2,vPercentFormat)).

I have set ExcelExportMixedAsText to 0 and in Document Properties field is set as number.

When exporting the table to excel I am getting General format which is not ok. How can I get Qlik to export it as Number?

Thank you!

[Anil_Babu_Samineni]

May be surround '$(vNumberFormat)'

[Chanty4u]

what is the variable output?  try to give the variable also with Num and try

[Anonymous]

Tried your solution but I keep getting the same thing.

[Anonymous]

vNumberFormat ='#,##0;(#,##0);-'

vPercentFormat ='#,##0.0%;(#,##0.0)%;-'

And obviously ThousandSep=',';  which is set in script.

[vardhancse]

Hi,

Chart properties->Number>Expression Default.

since you already defined number format in expression.

[Anonymous]

It is already set to Expression Default, because otherwise I can't get two different number formats in the chart.

[vardhancse]

In that case I think number formatting changes cane be done in QV level, but if we want same format in to excel then again manually we need to convert in excel .

If not we need to use some macros.

[Anonymous]

You mean macros in excel or Qlik?

[Anonymous]

Btw, now I have a new problem - after setting ExcelExportMixedAsText to 0 Month field values (MMM) are now exported as numbers.