How to display a string instead of '-' (null) in Qliksense?

[sumanta12]

I would like to display 'Departments' when the value is null(Yellow Marked) of SUBGROUP field.

[beck_bakytbek]

Hi Kumar,

check this:

https://www.youtube.com/watch?v=l20fjOQgbRc

i hope that helps

[pedrolyra]

Hey mate,

Use ALT function:

alt(sum(value),0)

where "0" is the "thing" you want to display instead of null

[mell90]

Hello  @sumanta12 ,

I have the same issue , did you found a solution ?

thanks