Multi condition text query

[AbFab]

Hi,

Brand new to Qlik Sense and I'm trying to construct a query, all I need is an output in a table.  In words my logic looks like this - the "-" are because they are returned for a null, not because they are input as a "-", but I can't filter in the application on the null:

Return my data if:

FieldA="textA" and FieldW="-"

Or

FieldA="textB" and FieldX="-"

Or

FieldA="textC" and FieldZ="-"

At the moment I'm just doing exports and Excel filtering, I'd love if I can get a query to do it!!!

Thanks in advance...

[martinpohl]

under dimensions, FieldW, uncheck null values

Regards

[AbFab]

Hi,

Thanks, but I perhaps didn't explain properly.

I've got "or" on these three conditions.  The conditions being that FieldA will have one of a few values and depending on the value I want to retrieve those that have a null in the relevant corresponding field.

So whatever is in FieldA tells me what it ought to be mapped to and then if there is a null under that mapping (FieldW, X or Z depending on what textA is) I need to input it in a database elsewhere so I want to filter on the null rather than exclude the null.

AbFab

[Kushal_Chawda]

what are the dimension and expression you are using?

[jonathandienst]

To compare null values, use IsNull() or Len() = 0:

FieldA="textA" and IsNull(FieldW) 
Or
FieldA="textB" and IsNull(FieldX) 
Or
FieldA="textC" and IsNull(FieldZ)