topic How to make a row not load in an expression in QlikView

How to make a row not load in an expression

Tue, 28 Feb 2012 16:20:52 GMT

Hi i'm looking for an expression to make a row not load if the data is blank in multiple rows, see example

Customer number , land line and Mobile details exist in different tables.

I want to write an expression where the Customer Number Row will disapear if there are no land line or mobile details(see row 4&5)

Ive tried suppress value when null which you can do one or either but not both because all the data disapears. Is there a work around to this?

Paul

swuehl — Tue, 28 Feb 2012 16:29:49 GMT

Paul,

do you want the line to be removed from your data entirely (i.e. during load in the script)?

Or just from showing in table chart object? If latter, which object type do you use, which dimensions and expressions?

I understood that the fields reside in different tables, how are these fields linked to each other?

jagan — Thu, 01 Mar 2012 08:22:47 GMT

Hi,

Find the attached file for solution. Hope it helps you.

Regards,

jagan.