Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in Qliksense normal table when background colour is applied, it is not applicable when null value appears, makes the table looks strange, any setting need be used to adjust for this? thanks
That is correct. Qlik Sense doesn't apply the background color when the cell is null. Behind the scenes, that 's because it doesn't put anything into that cell. The only work-around I've found is to put a space in the cell when it's null. Then the background color will get applied.
So... If(not IsNull([Your Field]), [Your Field], ' ')
I hope that helps.
That is correct. Qlik Sense doesn't apply the background color when the cell is null. Behind the scenes, that 's because it doesn't put anything into that cell. The only work-around I've found is to put a space in the cell when it's null. Then the background color will get applied.
So... If(not IsNull([Your Field]), [Your Field], ' ')
I hope that helps.