Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
panwipa2528
New Contributor III

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

I need everybody help me as below detail.


Raw Data


Result   Pivot Table

Tags (1)
9 Replies
Highlighted

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

May be like attached

Capture.PNG

Highlighted
vishsaggi
Esteemed Contributor III

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

How did you get P4 and P5 values as 0?

Highlighted
panwipa2528
New Contributor III

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

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

Highlighted

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

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

Highlighted
panwipa2528
New Contributor III

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

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

Highlighted

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

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

];

Highlighted
panwipa2528
New Contributor III

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

How about this?

Raw Data

Highlighted
dineshm030
Contributor II

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

Capture.PNG

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

Highlighted

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

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

Best,

Sunny