Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

agni_gold
Valued Contributor

Show "-" as 0 and consider in color coding in pivot table

Hi All,

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 ?

Tags (1)
1 Reply
thiago_justen
Valued Contributor III

Re: Show "-" as 0 and consider in color coding in pivot table

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:

If(Your_Measure=0,Yellow())

But, if instead this you want to do this only in the UI, maybe you should try this out:

If(IsNull(Diseases),0,Num(Diseases))

Cheers

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago