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: 
mphansalkar
Contributor
Contributor

>= sign not working in SET analysis

hi,

I am trying to use the following set analysis and running into the issue. I am counting number of claims by region ID.

sum({<RegionId = {2}>}PI_TotalClaimCnt) - this works ,

However I need to get claims for all regions with Region ID  >= 2. 

sum({<RegionId = ">={2}">}PI_TotalClaimCnt) - THIS DOES NOT WORK.

I have tried possible combinations of single quotes, double quotes, num(RegionID) however no luck yet.

Both fields are integers, but this formula is giving 0 value. Please help asap. 

 

thanks

Madhura

1 Reply
MayilVahanan

Hi @mphansalkar 

Try like below
sum({<RegionId = {">=2"}>}PI_TotalClaimCnt)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.