Appearence of 0 values Column in Pivot Table

[sarfaraz_sheikh]

Dear ALL,

In my pivot table one column(Co) has 0 values from initial stage till end like below..As of now 0 column values is not appearing in pivot table what should i have to do for appearence of 0 values column .........I have to show 0 values column also in my pivot table.

Grade                         IT                CE                Mech              Co          

A              Sum         50                 70                  40                   0
                 %            2                   10                  15                   0

B              Sum         50                 70                  40                   0
                 %            2                   10                  15                   0

C              Sum         50                 70                  40                   0
                 %            2                   10                  15                   0

Total          Sum        150                210                120                  0

                  %            6                    30                  45                  0

Sarfaraz

[sunilkumarqv]

Hi Sarfaraz,

try somthing like this

if(isnull(ERGO_LOC),0,ERGO_LOC) as ERGO_LOC

or

alt(ERGO_LOC,0) as ERGO_LOC

or

or use this in script

NullasValue Field1 ,Field2 ;

[qlikpahadi07]

Please share a sample that will be more helpful

[sarfaraz_sheikh]

Dears,

The tricks which you guys shared with me are not working as expected .....Kindly please check ...

Its urgent.

Sarfaraz

[sarfaraz_sheikh]

Dear Danial,

I tried what you suggested .....however nothing is impacting .....not getting as expected

Sarfaraz

[qlikpahadi07]

please share a sample

[sarfaraz_sheikh]

Dear All,

Please find my attached qvw here..

Sarfaraz

[sarfaraz_sheikh]

please find attached qvw here..

Sarfaraz