Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

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 ?

1 Reply
Thiago_Justen_

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
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago