topic Re: condition in QlikView

condition

Fri, 21 Nov 2014 15:03:32 GMT

is this request in correct:

=Count({<field1 !={'var'}>}field2)

JonnyPoole — Fri, 21 Nov 2014 19:03:34 GMT

It is not. != is not valid

Change:

=Count({<field1 !={'var'}>} field2)

To:

=Count({<field1 -={'var'}>} field2)

Fri, 21 Nov 2014 19:14:12 GMT

Hi,

You can use:

=Count({<field1 = field1 - {'var'}>} field2)

=Count({<field1 = {'*'}-{'var'}>} field2)

Best regards.

Fri, 21 Nov 2014 19:30:26 GMT

Write like below:

Count( {<field1 -={'var'}>} Field2 )

MarcoWedel — Fri, 21 Nov 2014 22:45:21 GMT

Hi,

depending on your requirements other solutions could be:

Where

=Count({1-1<field1={'var'}>} field2)

would count disregarding any selections, while

=Count({$-$<field1={'var'}>} field2)

only counts within the selections.

hope this helps

regards

Marco