topic Re: Selection In ListBox in QlikView

Selection In ListBox

Abhishek1 — Sat, 16 Nov 2024 03:15:10 GMT

Hi All,

I have a requirement wherein I have two listboxes, Both containing different Date fields. Field 1(List box 1) has MMM-YYYY format values. While Field 2(List box 2) has Dates in it. The requirement states that when values are selected in field 1, all the values in the second listbox(Field two) which are greater than the Max(Field 1) selection only needs to be shown. I have tried various different method but it dosent work as expected. Your help is appreciated.

Thanks

Re: Selection In ListBox

sunny_talwar — Wed, 19 Jun 2019 11:22:43 GMT

Would you be able to share what you tried thus far?

Re: Selection In ListBox

Abhishek1 — Wed, 19 Jun 2019 11:27:03 GMT

I tried extracting the maximum date of the maximum selection using:

=date(Monthend(date(MAx(Monthname(((YearMonth_FC)))))))

and then put an If condition in the second list box where dates greater than this dates are only to be shown.

I also tried putting this into a variable and using the Only() function with set analysis to get those dates.

Tried using getfieldselection(), but that dosent work

Re: Selection In ListBox

sunny_talwar — Wed, 19 Jun 2019 11:43:28 GMT

I meant would you be able to provide a sample qvw file where you have tried this?

Re: Selection In ListBox

Abhishek1 — Wed, 19 Jun 2019 11:54:38 GMT

I am sorry I cant. Cant share any data or data logic due to policies. I can help you with my requirement if I am not clear though.

Re: Selection In ListBox

sunny_talwar — Wed, 19 Jun 2019 12:00:42 GMT

I am neither looking for data nor data logic... all I am looking for is a mock up of your problem using mocked up data where we can see the issue and try to propose you a solution. If you are unable to do that, I am sure someone else might be able to offer help.

Best,
Sunny