NULL FIELD in QlikView

[Jamal]

Hi friends,

I need your help please, I m new In qlikView,

I have a table with different products and year, I ve create a straight table to show all products ( TS,TV,CAM,...)by year.

In 2018 I don't have a 'CAM' Product in the sqlserver table, and when click on clear in qlikView, I can see all products but when I select 2018 , I can't see the 'CAM' product.

I need that product to be shown even if there is no data in the table.

i need to sh

[Anil_Babu_Samineni · Accepted solution]

What is your intention here. If there is no data in DB, why are you expecting to see? Even. If you still want to get then my suggestion would to add inline for that like

DB table:
Concatenate
Load * Inline [
Product, Year
CAM, 2018
];

[MindaugasBacius · Accepted solution]

If I were in your shoes I would simple unselect this option - Superess Zero-Values:

Did it help?

[Jamal]

Hi,

Thanks Loveisfail, it works for me the Inline load.

I ve spent a day trying to figure out.

thank you all for you help.

[Jamal]

thanks bro,
the solution that gave me Loveisfail works for me.

thank you for your help.