Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ajsjoshua
Contributor III

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

Tags (1)
3 Replies
lironbaram
Honored Contributor II

Re: Condition in Expression

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
Contributor III

Re: Condition in Expression

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
Honored Contributor II

Re: Condition in Expression

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

Community Browser