topic Re: QlikView: How to show missing/zero values in Pivot Table and Calculate Total,%? in QlikView

QlikView: How to show missing/zero values in Pivot Table and Calculate Total,%?

panwipa2528 — Tue, 29 Aug 2017 14:03:54 GMT

I need everybody help me as below detail.

Raw Data

Result Pivot Table

sunny_talwar — Tue, 29 Aug 2017 14:29:44 GMT

May be like attached

vishsaggi — Tue, 29 Aug 2017 14:29:53 GMT

How did you get P4 and P5 values as 0?

panwipa2528 — Tue, 29 Aug 2017 14:59:52 GMT

If I Have P4 P5 from Master and want to show it all, How do I?

sunny_talwar — Tue, 29 Aug 2017 15:02:23 GMT

I feel like it should show up... have you tried it?

panwipa2528 — Tue, 29 Aug 2017 15:07:19 GMT

Can you explain about Dim that you load it?
What is the field, I have to use to replace Dim?

sunny_talwar — Tue, 29 Aug 2017 15:12:22 GMT

Dim is a field from an Island Table... you don't have to replace it, just need to add this to your application by adding this to your script

Dim:

LOAD * Inline [

Dim

];

panwipa2528 — Wed, 30 Aug 2017 10:54:58 GMT

How about this?

Raw Data

dineshm030 — Wed, 30 Aug 2017 11:26:07 GMT

If u have P4, P5 from the master, Result looks like this.

sunny_talwar — Wed, 30 Aug 2017 15:05:57 GMT

Since we resolved this in another thread, do you mind closing this thread down also.

Best,

Sunny