Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

condition

hi

is this request in correct:

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

4 Replies
Employee
Employee

Re: condition

It is not.  != is not valid

Change:

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


To: 

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

Not applicable

Re: condition

Hi,

You can use:

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

   or

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

Best regards.

Not applicable

Re: condition

Write like below:

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

Re: condition

Hi,

depending on your requirements other solutions could be:

QlikCommunity_Thread_143153_Pic1.JPG.jpg

QlikCommunity_Thread_143153_Pic2.JPG.jpg

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

Community Browser