topic Exclude a row in a table, based on a condition? in QlikView

Exclude a row in a table, based on a condition?

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

Hi,

If I have

-Part Number

- Description

- Onhand-Qty

as columns in a table, how do I prevent rows where the 'Onhand-Qty' = 0 from being shown?

I've tried Aggr function, If statement etc, but can't figure it out.......

I can suppress the '0' and get '-' instead, but I can't get the rows to be excluded.

Thanks.

Re: Exclude a row in a table, based on a condition?

sunny_talwar — Mon, 29 Jan 2018 17:06:06 GMT

Not syre, but have you tried set analysis?

{<[Onhand-Qty] -= {'0'}>}

Re: Exclude a row in a table, based on a condition?

stephenhasson — Tue, 30 Jan 2018 08:48:34 GMT

Thanks for your reply. I've tried all sorts of variations...... Not sure if I even should be trying to use set analysis or condition logic? Can't find any suitable documentation.

Stephen

Re: Exclude a row in a table, based on a condition?

sunny_talwar — Tue, 30 Jan 2018 12:17:06 GMT

Would you be able to share a sample to show what you have and explain what you need to get from it?