Discussion board where members can get started with Qlik Sense.
I have one pivot table , but i am getting some "-" values there . but i want to show them as 0 and want to color as well based on condition.
Can it be possible ?
Maybe this will be helpful.
Into your load script you can do something like this:
If(IsNull(Diseases),0,Num(Diseases)) as Diseases
Then in UI you can put this expression,for instance, to text color:
But, if instead this you want to do this only in the UI, maybe you should try this out: