This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
=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'