Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

Column data need to align in right side in excel

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 :                           

 

RKULKARNI4_3-1603084962336.png

 

                            

 

In Excel :

RKULKARNI4_4-1603084994534.png

 

Please advise .

 

Regards

Rk

 

 

2 Replies
ArnadoSandoval
Specialist II
Specialist II

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

  • Change the column's field expression to =Floor(<field_name>)
  • Set Custom alignment to the Right:

2 - Measure:

  • Change its Number formatting to Number.
  • Change formatting to Custom.
  • Enter the Formatting pattern to: ###0

The solution in pictures:

90.Export-Align-01.png

90.Export-Align-02.png

90.Export-Align-03.png

Hope this helps,

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
RKULKARNI4
Contributor III
Contributor III
Author

After applying this formula it got worked for some columns.I have issue with one column.

Before applying floor formula the output mentioned below :

RKULKARNI4_0-1603092622392.png

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