How to replace NULL in the Table chart

[vinay_qlik]

Hi Team,

I have 2 columns called Impac_1 & Impact_2. 

There are NO null values in the source columns.

But same are appearing while I am using Table Chart. (Uncheck NULL values is not the option I am looking for)

Please refer the attachment where I need to replace the NULLs to a value.

Thanks In Advance

[agni_gold]

Are these columns from the same table or from two different tables, if from different tables, how you are linking both the table, are you making any join or just doing association?

[joshuahirsch]

Yes, could you make a Screenshot of the Data Model?

[vinay_qlik]

Hi Agni,

Those are from 2 different tables and connected on a KEY.

[agni_gold]

In that case, it will be a full outer join between both the tables, i would suggest, if you want to remove these null, please go for the join.

[marcus_malinow]

It seems that although your fields are 100% populated, the key between your tables is not perfect

See this post for some more information on this

https://community.qlik.com/t5/QlikView-App-Development/Perfect-Key/m-p/360567