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

[panwipa2528]

I need everybody help me as below detail.

Raw Data

Result   Pivot Table

[sunny_talwar]

May be like attached

[vishsaggi]

How did you get P4 and P5 values as 0?

[panwipa2528]

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

[sunny_talwar]

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

[panwipa2528]

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

[sunny_talwar]

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

1

2

3

];

[panwipa2528]

How about this?

Raw Data

[dineshm030]

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

[sunny_talwar]

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

Best,

Sunny