topic Re: requirement in QlikView

requirement

Anonymous — Thu, 01 Feb 2018 11:43:38 GMT

I have two filter some conditions like:

where x='some value' and y='some value' and z=null or z='na'

how to do that ?

Peter_Cammaert — Thu, 01 Feb 2018 12:07:05 GMT

IF ((x = 'some value') and (y = 'some value') and (IsNull(z) or (z = 'na')), true-expression, false-expression)

its_anandrjs — Thu, 01 Feb 2018 12:40:07 GMT

If you are using this conditions in where condition to filter the data then

Load *

From source

Where

x = 'some value' and y = 'some value' and isnull(z) = -1 or z = 'na';

Or in the conition

If( x = 'some value' and y = 'some value' and isnull(z) = -1 or z = 'na',1 ,0 )