topic Re: NULL FIELD in QlikView in QlikView

NULL FIELD in QlikView

Jamal — Sat, 26 Jan 2019 21:47:12 GMT

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

Re: NULL FIELD in QlikView

Anil_Babu_Samineni — Sun, 27 Jan 2019 00:24:09 GMT

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
];

Re: NULL FIELD in QlikView

MindaugasBacius — Sun, 27 Jan 2019 09:54:21 GMT

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

Did it help?

Re: NULL FIELD in QlikView

Jamal — Sun, 27 Jan 2019 11:47:53 GMT

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.

Re: NULL FIELD in QlikView

Jamal — Sun, 27 Jan 2019 11:49:57 GMT

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

thank you for your help.