This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a straight table in qlik sense, one of the columns is percentage values: Num(FieldPerc,'#.###%')
Mi problem is that once I expot this table, '0%' values become just '%' in Excel:
When doing calculations in excel it works as if it's 0 but I'm requested to show this values as 0% also in excel.
This doesn`t happen with other number columns in the table with money format.
Thanks a lot in advance
can u try to put it as a measure? and let the format handled by qlik? (the % one?)
View solution in original post
does it do the same thing when u try to export this column without the num()?
I've tried, and found out something interesting:
- First column: as Dimension (lose the % format)
- Second column: as you suggest, without the Num(). It works when exporting to excel, the 0% appears as in QS, theroblem is that I lose the % format in the total row in QS
- The third row is as I have it now, with the Num(%), all ok except for the 0% values when exporting.
Indeed, that worked. I has the format as auto since I was formating the measure in the expression, but setting it to Number, that way worked.
Thanks a lot.
With the LogiExport extension for QlikSense you can control the formatting of the exported file: