topic How to hide the row with set analyst in QlikView

How to hide the row with set analyst

Mon, 21 Jan 2013 03:38:06 GMT

Dear All,

Do you have a method to hide the row with set alalyst.

For example, there are two expressions "Qty" and "Delivery".

If the "Delivery" >= "Qty" then hide the row.

Please give me some suggestions. Thanks a lot

Mon, 21 Jan 2013 05:28:18 GMT

Hi,

you can do this by caluculated dimensions.

refer the attached file.

Niranjan M.

Wed, 23 Jan 2013 06:12:06 GMT

Hi,

Thank you for help. It's really useful for me.

In your example, the calculated dimensions work well.

But in my case, the qty is changed depend on condition which the user selected.

In a word, my case is complexer than yours.

Can you help to analyse my case in the attachment?

My expected result is hide the row when the open sale qty is less then 0.

The open sale qty is equal to (qty - delivery qty).

The delivery qty is dynamic change depend on the date which the user selected.

Thank you very much