topic Re: Substruction of listbox data in QlikView

Substruction of listbox data

Wed, 26 Jun 2013 13:29:16 GMT

Hi,

Consider a case of 2 listboxes;

1st listbox has data 'April' and 'June'

When April is chosen 10 items are being selected and when it is June 12 items are being selected in the 2nd listbox

I want to show the differential 2 items in the 3rd listbox.

How can I achieve that without touching the query?

Thanks

Re: Substruction of listbox data

Gysbert_Wassenaar — Wed, 26 Jun 2013 13:30:46 GMT

See this discussion

Re: Substruction of listbox data

Thu, 27 Jun 2013 10:10:50 GMT

Thanks for your reply.

In that example, the expression intersects 2 different listboxes. I have only 1. Do I need to -duplicate- the listbox (using resident?)? Is there any simpler way without duplicating?

Thanks!

Re: Substruction of listbox data

Gysbert_Wassenaar — Thu, 27 Jun 2013 18:46:49 GMT

See attached example.

Re: Substruction of listbox data

Thu, 04 Jul 2013 13:56:51 GMT

I have tried with the attached document.

I could not understand the expression but ur sample works fine. In your example you have 2 items in your month listbox, so they basically intersects with the other item.

I have more than 2 items in the month listbox so when I tried the exact same expression it did not work for me. How should I change the expression so that interesection is done between the selected item and the previous one.

Thanks a lot!

Re: Substruction of listbox data

Wed, 10 Jul 2013 06:39:38 GMT

Considering a listbox with more than 2 items, is it possible to change the expression so that intersection is done between the selected item and the previous item of the selected.

For ex: There are months in the listbox(but consider them as text data not real dates), when I choose June I want the 2nd listbox intersects with the May's data. If it February is selected, it should intersect with January's data.

Thanks!