Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be surround '$(vNumberFormat)'
what is the variable output? try to give the variable also with Num and try
Tried your solution but I keep getting the same thing.
vNumberFormat ='#,##0;(#,##0);-'
vPercentFormat ='#,##0.0%;(#,##0.0)%;-'
And obviously ThousandSep=','; which is set in script.
Hi,
Chart properties->Number>Expression Default.
since you already defined number format in expression.
It is already set to Expression Default, because otherwise I can't get two different number formats in the chart.
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.
You mean macros in excel or Qlik?
Btw, now I have a new problem - after setting ExcelExportMixedAsText to 0 Month field values (MMM) are now exported as numbers.