Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
Former Employee
Former 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