Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
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 .
Regards
Rk
Hi @RKULKARNI4
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 :
Broker Number |
801 |
801 |
801 |
801 |
801 |
802 |
801 |
801 |
801 |
801 |
801 |
Please advise .
Regards
RK