topic Re: Expression using an OR clause in QlikView

Expression using an OR clause

Mon, 23 May 2016 00:41:33 GMT

I am trying to put together a criteria in an expression.

Essentially an OR case

Currently I have :

count({<Stream={'1'}>} CarNP)

I want to add where it is Stream 1 OR Colour like Red. As the cars maybe in Stream 1 or in another stream but have red within the colour field

count({<Stream={'1'}, Colour = {'*Red*'}>} CarNP)

tamilarasu — Mon, 23 May 2016 09:10:07 GMT

Try this,

count({<Stream={'1'}> + <Colour = {'*Red*'}>} CarNP)

Chanty4u — Mon, 23 May 2016 10:36:47 GMT

try

count({<Stream={'1'} and Colour = {'*Red*'}>} CarNP)

Mon, 23 May 2016 10:40:40 GMT

=count(if([Stream] = '1' OR 'Colour = '*Red*' , CarNP)) ;

Kushal_Chawda — Mon, 23 May 2016 10:42:13 GMT

=Count(if(Stream='1' or Colour like '*Red*',CarNP))

chetansehgal — Mon, 23 May 2016 11:01:45 GMT

=count({<Colour={'RED'}>+< Stream={1}>}CarNP) works fine.

jonathandienst — Mon, 23 May 2016 11:23:28 GMT

The suggestion by tamilarasu is the correct one. Some of the others will work, but will not be as quick. Others will not work at all.

sunny_talwar — Mon, 23 May 2016 12:45:39 GMT

I second that

swuehl — Mon, 23 May 2016 12:52:27 GMT

Maybe it's also possible to use

=Count({<CarNP = p({<Stream={'1'}>}) + p({<Colour = {'*Red*'}>}) >} CarNP)

avoiding the union of two record sets