Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

display text last

Hi all

I want to display text along with measure

   [  kPI ] object

I tried below but I need last

='Days'& avg(Days)      result  Days10

but I need result   like     10 Days

Tags (2)
1 Solution

Accepted Solutions
YoussefBelloum
Esteemed Contributor

Re: display text last

=Floor(avg(Days)) &' Days'

9 Replies
YoussefBelloum
Esteemed Contributor

Re: display text last

Hi,

=avg(Days) &' Days'

soniasweety
Contributor III

Re: display text last

thanks.

but after adding that  the kpi value  displaying like    10.08169 days   I need exact 10days

checked in number format it is set to 1000

YoussefBelloum
Esteemed Contributor

Re: display text last

=Floor(avg(Days)) &' Days'

soniasweety
Contributor III

Re: display text last

thanks used below

YoussefBelloum
Esteemed Contributor

Re: display text last

you're welcome

soniasweety
Contributor III

Re: display text last

one quick question youssef belloum

if I use floor its giving without decimals.

if want one decimal means how can I use?

like 10.2 days ?

YoussefBelloum
Esteemed Contributor

Re: display text last

Floor: rounds the value down

Ceil: rounds the value up

you can try this:

=Num(avg(Days),'# ##0,0') &' Days'

soniasweety
Contributor III

Re: display text last

tried this working   thanks

num(avg(Days),'###.#') & chr(10)&'Days'

YoussefBelloum
Esteemed Contributor

Re: display text last

you're welcome.

Good luck

Community Browser