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

conditions

Hello Guys,

I need to write those conditions in set analysis ;

IF type cas ='demande' and custcode <=2 and categorie <>'test' and categorie <>'bip'


Tha measure is count (code_cas)


Thanks

4 Replies
antoniotiman
Master III
Master III

Count({<[type cas]={'demande'},custcode={'<=2'},categorie-={'test'}>} DISTINCT code_cas)

Regards,

Antonio

vinieme12
Champion III
Champion III


count ({<[type cas]={'demande'},custcode={"<=2"},categorie -={'test','bip'}>code_cas)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anil_Babu_Samineni

May be missed closed flower Bracket

count ({<[type cas]={'demande'},custcode={"<=2"},categorie -={'test','bip'}>} code_cas)


Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ahaahaaha
Partner - Master
Partner - Master

May be

Count({<[type cas]={'demande'},custcode={"<=2"),categorie-={'test', 'bip'}>} code_cas)