topic Re: Help Hiding a row in QlikView

Help Hiding a row

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guy's

I have the following sheet as shown below. I would like to hide all rows where the expression "date count" fields is 3. Is this possible ?

Kind regards

Re: Help Hiding a row

sunny_talwar — Thu, 21 Apr 2016 15:35:45 GMT

May be use this kind of logic for all your expressions, except date count expression

If([date count] <> 3, yourexpreission)

and for date count expression

If(expression <> 3, expression)

Re: Help Hiding a row

Tue, 26 Apr 2016 08:42:22 GMT

Thanks so Much Sunny

I tried the following in a calculated dimension and it worked.

=Aggr(if(isNull(MaxString([Shipment Document Release Date])) or IsNull(MaxString([Actual Discharge Date])) or IsNull(MaxString([Final Payment Recieved])), [Our Shipment Reference]), [Our Shipment Reference])

Regards

Re: Help Hiding a row

sunny_talwar — Tue, 26 Apr 2016 15:59:59 GMT

Great, I am glad you were able to figure it out. Please close the thread now