11 Replies Latest reply: Sep 14, 2017 5:16 AM by Sasi Vardhan KV RSS

    Exporting to excel as number

    Andrejs Lapins

      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!