Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Appearence of 0 values Column in Pivot Table

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

16 Replies
sunilkumarqv
Specialist II
Specialist II

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
Specialist
Specialist

Please share a sample that will be more helpful

sarfaraz_sheikh
Contributor III
Contributor III
Author

Dears,

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

Its urgent.

Sarfaraz

sarfaraz_sheikh
Contributor III
Contributor III
Author

Dear Danial,

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

Sarfaraz

qlikpahadi07
Specialist
Specialist

please share a sample

sarfaraz_sheikh
Contributor III
Contributor III
Author

Dear All,

Please find my attached qvw here..

Sarfaraz

sarfaraz_sheikh
Contributor III
Contributor III
Author

please find attached qvw here..

Sarfaraz