Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

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
Not applicable

Re: alignment text


Use round function like

round(ColumnName,0)+' days'

Not applicable

Re: alignment text

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

Not applicable

Re: alignment text

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