Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

condition

hi

is this request in correct:

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

4 Replies
JonnyPoole
Employee
Employee

It is not.  != is not valid

Change:

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


To: 

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

Not applicable
Author

Hi,

You can use:

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

   or

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

Best regards.

Not applicable
Author

Write like below:

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

MarcoWedel

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