If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I would like to display 'Departments' when the value is null(Yellow Marked) of SUBGROUP field.
Hey mate,
Use ALT function:
alt(sum(value),0)
where "0" is the "thing" you want to display instead of null