Row hide in Qlikview

[mhmmd_srf]

Hi All,

I have on Straight Table. Where I want to hide rows on the basis of One field that is Stocks Unit Frozen. This is conditional field based on the Selection of Frozen Flag.

Which row is having Stocks Units Frozen =0, I want to hide those row.

Could you please help me do the same.

I am attaching the sample app. Please help.

Thanks,

Sarif

[prma7799]

You want to remove  values for column Cost also because of Cost you are getting 0 for Stocks Units Frozen

[Anil_Babu_Samineni]

I don't have qlikview software, I will give antonym in different orient which are

1) Create flag same where the condition is opposite to only one value like If(Expression condition ..., 1) as Flag

2) Or else, You can do this in calc. dim like If(FieldName <> 0, FieldName) then give label as FieldName

HTH

Anil

[antoniotiman]

HI,

Expression Cost :

If(Column(1) <> 0,
sum(DIM_ITEM.ItemStandardCostPerStockUnit))

Regards,

Antonio

[#5]

Hi Sarif,

Add if condition to check column(1) <> 0 in all expression.