Discussion board where members can get started with Qlik Sense.
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
Go to Solution.
=Floor(avg(Days)) &' Days'
View solution in original post
=avg(Days) &' Days'
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
thanks used below
=Floor(avg(Days)) &chr(10) &' Days'
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 ?
Floor: rounds the value down
Ceil: rounds the value up
you can try this:
=Num(avg(Days),'# ##0,0') &' Days'
tried this working thanks
num(avg(Days),'###.#') & chr(10)&'Days'