Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator III

alignment text

Hi Community,

i'm using this formula

IF(([DateDTCURC] - [DateDTRIRC]) < 1, Interval([Closed Time1] - [Request Time1] ), num((DateDTCURC - DateDTRIRC), '#.###') & ' ' & 'days')

My question is:

how could I set a right alignment (Elapsed Time)?

may I align EImmagine.png

3 Replies
muniyandi
Creator III
Creator III

Hi

Use round function like

round(ColumnName,0)+' days'

ArnadoSandoval
Specialist II
Specialist II

Hi Fabio,

Follow these steps:

  1. Enter Edit Mode
  2. Click on the table
  3. Click on Data on the right side of the screen.
  4. Select the column you want to align (Elapsed Time)
  5. Scroll down to text alignment, un-check automatic
  6. Select right alignment.

See screenshot

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
Not applicable

I'm using a pivot table and there's no option like 'Text Alignment' . How can I adjust alignment on pivot table??