If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have one numeric column in Qlik sense it is appearing right side .But when i export the same thing in excel it is appearing in the left side .But i want to display in the right side even in excel format.Please refer the screenshot below :
Qlik sense :
In Excel :
Please advise .
I tried the possibilities I could think of: (1) The column is a dimension (2) The column is a measure; this is how to format them so Excel shows them as numeric:
1 - Dimension:
2 - Measure:
The solution in pictures:
Hope this helps,
After applying this formula it got worked for some columns.I have issue with one column.
Before applying floor formula the output mentioned below :
After applying floor formula the output mentioned below :