Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Condition in Expression

Dear all,

My condition CurrentNPABucket={">=4"}  doesn't works

Expression:

count(distinct {<Type={'CurrentOD'},Month=,YearMonth=, YearMonthKey ={"$(vMaxMonthSelect)"},CurrentNPABucket={">=4"}>} LOANKEY)

I am getting the same number as this expression

count(distinct {<Type={'CurrentOD'},Month=,YearMonth=, YearMonthKey ={"$(vMaxMonthSelect)"}>} LOANKEY)

Capture.PNG

3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

quite hard to understand what is the problem you try to raise

can you share sample data or explain a little more

according to your image you  only display points that are equal or bigger than 4 which is what

you try to achieve so what  is the problem?

ajsjoshua
Specialist
Specialist
Author

Dear Liron,

Actually my CurrentNPABucket field has values 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,72 i want to find LOANKEY which are CurrentNPABucket>=4.


But this condition doesnt works.



Regards,

Joshua.

lironbaram
Partner - Master III
Partner - Master III

Hi Joshua

i understand your need , and on the surface your expression seems right

what exactly you display in the image , and what expression you used in the field you display