Solved: Why i select Label = > 5 Yr it not turn green ? - Qlik Community

paulyeo11 · ‎2017-12-20

Hi All

I have a list box , which having :-

<6 Mth

> 6 Mth - 1 Yr

>2-3 Yr

>3-4 Yr

>4-5 Yr

> 5 Yr

I notice that when i select all other label is okay , because it turn Green , except >5Yr , it turn white.

Can some one tell me why ?

Paul

Anil_Babu_Samineni · ‎2017-12-20

Because, In your statement you have 2 Dual carrying same value?

If([No of Months_] >= 85 , Dual('> 5 Yr',7), Dual('> 5 Yr',7)

Remove Dual('> 5 Yr',7) and use ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

paulyeo11 · ‎2017-12-20

My QVW

Anil_Babu_Samineni · ‎2017-12-20

Because, In your statement you have 2 Dual carrying same value?

If([No of Months_] >= 85 , Dual('> 5 Yr',7), Dual('> 5 Yr',7)

Remove Dual('> 5 Yr',7) and use ..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

paulyeo11 · ‎2017-12-20

Hi Anil

Many thank.

Paul