Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai_Mohan
Contributor III
Contributor III

How to use If condition in getselectedcount function

Hi Team,

How to use if condition inside getselectedcount.

For Example:

There is a table in which I need to show country names based on selecting a countryID.

In Add on Property -> Data handling -> I have given this condition as IF(GetSelectedCount( countryId)>=1, 1,0)

but I need to give this countryid with some extra condition as IF(GetSelectedCount( IF([CountryName]='India', CountryId)) >=1, 1,0) - So that I will get values only for india

Thanks

Sai

Labels (3)
3 Replies
Aditya_Chitale
Specialist
Specialist

IF(wildmatch(CountryName,'India') and GetSelectedCount(countryId)>=1, 1,0)

Regards,

Aditya

Sai_Mohan
Contributor III
Contributor III
Author

Hi Aditya,

Thanks for the reply.

Im getting error in expression

Error - Wildmatch takes atleast two parameters if i try above wildmatch expression

Please help me with this

Aditya_Chitale
Specialist
Specialist

make sure you have used correct syntax. Refer below link/

Wildmatch 

Regards,

Aditya