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: 
bobbydave
Creator III
Creator III

One selection selects another selection from listbox

I've a loader that takes in the below expressions:

   if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] <=5,1)               as [Completed CFIN Including Web <= 5 Days],

    if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] <=10,1)               as [Completed CFIN Including Web <= 10 Days],

    if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] >10,1)               as [Completed CFIN Including Web >10 Days],

     

    if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] <=5,1)               as [SLA CFIN Including Web <= 5 Days],

    if(MixMatch([Case Type],'CFIN','WFIN') and [Recd To Close] >5 and [Recd To Close] <=10,1)         as [SLA CFIN Including Web <= 10 Days],

    if(MixMatch([Case Type],'CFIN','WFIN')and [Recd To Close] >10,1)               as [SLA CFIN Including Web >10 Days],

In my app, I bring these expression values and put them in a listbox

=IF( [SLA CFIN <= 5 Days], 'SLA CFIN<=5 Days',

if([SLA CFIN <= 10 Days], 'SLA CFIN =<10 Days',

  if([SLA CFIN > 10 Days], 'SLA CFIN>=10 Days',

   if( [SLA CCIN <= 5 Days], 'SLA CCIN <= 5 Days',

    if([SLA CCIN <= 10 Days], 'SLA CCIN <= 10 Days',

     if([SLA CCIN > 10 Days], 'SLA CCIN > 10 Days',

      if([SLA CCIN Including Web <= 5 Days], 'SLA CCIN Including Web <= 5 Days',

       if([SLA CCIN Including Web <= 10 Days], 'SLA CCIN Including Web <= 10 Days',

        if( [SLA CCIN Including Web >10 Days], 'SLA CCIN Including Web >10 Days' 

   )))))))))

My problem is when i make a selection from the listbox, when i select

'SLA CCIN <= 5 Days' from the listbox,

'SLA CCIN Including Web <= 5 Days then also gets selected.

the same applies to 'SLA CCIN <= 10 Days', then

'SLA CCIN Including Web <= 10 Days' gets selected also

and  CCIN >10 also.

I've added a picture of me selecting CCIN <= 5 Days only

However a second selection is made of CFIN including Web >= 5 days.

**Note if I first select the other way around, as in, CCIN including Web, the second selection is not made. Weird

Anyone understand why 2 selections are made for 1 selection.

Thanks

2 Replies
Colin-Albert

Th think you need to change the order of the if statements in the listbox expression so the most inclusive statements come first.

i.e.

IF  SLA CCIN inc Web ...

      IF  SLA CCIN inc Web ...

           IF  SLA CCIN inc Web ...

                IF  SLA CCIN ...

                     IF  SLA CCIN ...

                          IF  SLA CCIN ...

                               IF  SLA CFIN ...

                                    IF  SLA CFIN ...

                                         IF  SLA CFIN ...

bobbydave
Creator III
Creator III
Author

I've tried rearranging the order.

Its very strange that it is only the SLA CCIN will automatically select the SLA CCIN Incl Web.

Nothing has worked