Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
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
Partner

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

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
Partner

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