topic Row hide in Qlikview in QlikView

Row hide in Qlikview

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Row hide in Qlikview

prma7799 — Fri, 30 Jun 2017 05:35:35 GMT

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

Re: Row hide in Qlikview

Anil_Babu_Samineni — Fri, 30 Jun 2017 05:36:32 GMT

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

Re: Row hide in Qlikview

antoniotiman — Fri, 30 Jun 2017 05:39:00 GMT

HI,

Expression Cost :

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

Regards,

Antonio

Re: Row hide in Qlikview

Fri, 30 Jun 2017 06:08:25 GMT

Hi Sarif,

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