Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
fmazzarelli
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
muniyandi
Not applicable

Re: alignment text

Hi

Use round function like

round(ColumnName,0)+' days'

tinaco110
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??