topic Re: Null values in Pivot TABLE in QlikView

Null values in Pivot TABLE

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am getting these null values in pivot table.Interestingly there are no null values in the fields for which pivot table is giving null values,Please help.

Screenshot attach

App are also attach we are using two tier achitecture one is qvd generator and other one final application.

Issue is in the Pivot table of first tab .Please help

Re: Null values in Pivot TABLE

Chanty4u — Tue, 20 Mar 2018 16:48:18 GMT

try to debug

take a copy of table.

remove one by one dimension and check which dimension you are having the null value.

based on dimension the related values may not avaiable

try to uncheck the dimension tab suppress null values for dimensions

Re: Null values in Pivot TABLE

shiveshsingh — Tue, 20 Mar 2018 16:49:49 GMT

Can you share your app? May be for some dimension you don't have value..u need to check

Re: Null values in Pivot TABLE

Digvijay_Singh — Tue, 20 Mar 2018 17:38:21 GMT

Its not necessary that you get null values only when you have null values in any of the field. You might get null values when you choose fields in your pivot tables from different tables and they don't give you valid combinations based on matching keys. You may like to verify your dimension values for which you are seeing null values in your pivot table.

Re: Null values in Pivot TABLE

manu1512 — Wed, 21 Mar 2018 11:41:58 GMT

done

Re: Null values in Pivot TABLE

manu1512 — Wed, 21 Mar 2018 11:42:47 GMT

stalwar1‌cleveranjos‌s10157754‌ pls help

Re: Null values in Pivot TABLE

sunny_talwar — Wed, 21 Mar 2018 11:49:23 GMT

Some of the fields (for example, Avdelning and Enhet) are coming from CO_Objekt which have a subset ratio of 97%... meaning... not everything in Data have a match within CO_Objekt... hence the nulls

Re: Null values in Pivot TABLE

Chanty4u — Wed, 21 Mar 2018 11:59:00 GMT

woow Nice sunny

Re: Null values in Pivot TABLE

manu1512 — Wed, 21 Mar 2018 12:36:19 GMT

Hi Sunny ,

Many thanks for the Solution,Would b grateful if you can suggest new solution to remove this .

Re: Null values in Pivot TABLE

sunny_talwar — Wed, 21 Mar 2018 12:42:00 GMT

You want to get rid of these from the data model or just from the chart? For chart, you can select Suppress When Value Is Null on the dimension tab for the dimensions which are showing null....

Re: Null values in Pivot TABLE

manu1512 — Wed, 21 Mar 2018 12:47:21 GMT

I tried removing from the chart by supressing it ,but client wants to remove from data model?Any help

Regards

Manu

Re: Null values in Pivot TABLE

sunny_talwar — Wed, 21 Mar 2018 12:51:16 GMT

Load CO_Objekt first and then load Data with Left Keep (CO_Objekt) and then Kostelem, ProjektInvCo, and Kostelem with Left Keep(Data)

Re: Null values in Pivot TABLE

manu1512 — Wed, 21 Mar 2018 13:11:46 GMT

Hi Sunny,

Thanks for the help but unfortunately i am not getting desired result.Would be grateful if you can check where i am getting wrong, some values of column of Pivot table are getting null values.

Regards
Manu

Re: Null values in Pivot TABLE

sunny_talwar — Wed, 21 Mar 2018 13:16:51 GMT

Can you share the new script that you tried?

Re: Null values in Pivot TABLE

manu1512 — Wed, 21 Mar 2018 13:25:28 GMT

yes already shared the application in the main post OKG_Controlling_Test qvw.

Thanks in advance stalwar1‌

Re: Null values in Pivot TABLE

sunny_talwar — Wed, 21 Mar 2018 13:31:57 GMT

With the changes that I mentioned manu1512‌

Re: Null values in Pivot TABLE

manu1512 — Wed, 21 Mar 2018 13:36:28 GMT

Hi Sunny ,

Yes OKG_Controlling_Test qvw. contains the changes mentioned by you.I dont know how to attach application in comments.Please check and let me know my mistakes

Regards

Manu

Re: Null values in Pivot TABLE

manu1512 — Wed, 21 Mar 2018 13:41:58 GMT

stalwar1‌ Please help

Re: Null values in Pivot TABLE

manu1512 — Wed, 21 Mar 2018 14:11:02 GMT

Hi Sunny,

I would be grateful if you can help me more to acheive the desired result.

Regards

Manu

Re: Null values in Pivot TABLE

sunny_talwar — Wed, 21 Mar 2018 14:14:01 GMT

Not sure, but I see that the data is not loading into Data table after the Left Keep. I am still looking...