topic Re: Help in Set analysis 'And' operator in QlikView

Help in Set analysis 'And' operator

Mon, 02 Sep 2013 11:15:59 GMT

Hi,

As I need to exclude the values from the chart and the table if the status is 'A' and the Code is '#'

1. I would like to exclude the [Status] = 'A' and the [Code] = '#', as I tried in the below but it exclude all Status 'A' invoices

=Count({$<[Status]-={'A'} , [Code]-={'#'}>}DISTINCT([Transactions]))

Regards

Chriss

nizamsha — Mon, 02 Sep 2013 11:18:47 GMT

=Count({$<[Status]={'*'} ,[Status]-={"A"} [Code]-={'#'}>}DISTINCT([Transactions]))

tresB — Mon, 02 Sep 2013 11:20:49 GMT

try:

Count({$<[Status]-={'A'} > * < [Code]-={'#'}>}DISTINCT([Transactions]))

orital81 — Mon, 02 Sep 2013 11:30:29 GMT

You can always add a flag field (in the script or as a variable)

that will something like this:

If ([Status] = 'A' and the [Code] = '#',1,0)

Then your set analysis will be more simple and easy to adjust

Count({<Flag = {'1'}>} DISTINCT([Transactions]))

CELAMBARASAN — Mon, 02 Sep 2013 11:32:48 GMT

May be like this

=Count({$<[Transactions]={"=[Status]<>'A' and [Code]<>'#'"}>} DISTINCT [Transactions])

Count({$-(<[Status]-={'A'} > * < [Code]-={'#'}>)}DISTINCT [Transactions])

MayilVahanan — Mon, 02 Sep 2013 11:34:49 GMT

Try like this

Count({$-(<[Status]-={'A'} > * < [Code]-={'#'}>)}DISTINCT [Transactions])

Mon, 02 Sep 2013 12:05:33 GMT

Hi All,

Thanks for your valuable reply now the expression is working fine...

Regards

Chriss