Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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