topic Re: How to remove data from a List box based on Data selected in other listbox ? in QlikView

How to remove data from a List box based on Data selected in other listbox ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

I have Two list boxes with name as folows
1) Select Date

2) Result Date

Both uses same field from table .

My requirement is that when user selects a value in Select Date List box , then that particular value should be removed from Result Date list box but when user deselects a value then from Select Date List box then that value should re appear or retained in Result Date List Box .

Thanks & Regards

Shekar

Re: How to remove data from a List box based on Data selected in other listbox ?

awhitfield — Tue, 18 Apr 2017 13:43:39 GMT

Why do you want to do this? What are you actually trying to achieve?

Andy

Re: How to remove data from a List box based on Data selected in other listbox ?

shekhar_analyti — Tue, 18 Apr 2017 13:49:13 GMT

I just wanted to know , if this can be done ? Answer to this will lead me to a much needed solution ...

Re: How to remove data from a List box based on Data selected in other listbox ?

awhitfield — Tue, 18 Apr 2017 14:07:47 GMT

Sounds like you actually want to display all values except those selected in a chart perhaps, rather than in another list box??

May be like this?

In which case you could use set analysis to display values whose dates are exclude by your selection, e.g.

Sum({<Date = e(Date)>}Sales)

as the expression in the chart show??

Andy

Re: How to remove data from a List box based on Data selected in other listbox ?

Peter_Cammaert — Tue, 18 Apr 2017 14:07:48 GMT

It can be made to work if you select at least one value in [Select Date]. Otherwise the Result Date list will be empty because clicking the Clear button will mean "everything selected".