Show all values giving me 0 as a dimension value.

[#1]

Hi All,

I am trying to poapulate all dimension with values though corresponding data is not there in the source using show all option.

This gives me the result.But along with that additional row and column with 0 as the dimension value is coming into picture.

Can any one help me with this(to remove the same).I am pretty new to qlikview.

[sushil353]

Hi,

In presentation tab check supress zero values.

HTH

Sushil

[jagan]

Hi Pooja,

It is a null value, try selecting Supress When Value is Null option in Dimension tab.

Regards,

Jagan.

[#4]

But Suppress zero will eliminate the rest of the dimensions too in which the values are zero right?

In the above example i have dimensions where the values are 0s eg CLC,DU etc.I need to populate that.

My requirement is like I need all valid dimensions except 0.

[#5]

But Suppress null will eliminate the rest of the dimensions too in which the values are zero right?

In the above example i have dimensions where the values are 0s eg CLC,DU etc.I need to populate that.

My requirement is like I need all valid dimensions except 0.Is it possible.

[avinashelite]

Hi Pooja,

Can you please attach your app!!

Regards,

@vi

[jagan]

Hi,

Then in your expression try

Sum({<DimName-={0}>} MeasureName)  //Excluding zero from Dimension

If this not works then attach sample file.

Regards,

Jagan.

[#8]

Please find the attached application.

In that i need to populate all fields in UNIT without 0 populated in any of the dimensional value.(Dimiension TYPE is having a value 0 and unit is having a value 0).My output should look like below.

[jagan]

Hi Pooja,

Please find attached file, hope it helps you.  Modified some script.

Regards,

jagan.