topic Re: listbox from and to date in QlikView

listbox from and to date

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have listbox which has text column, user wants to select from and to fields based on text column, please let me know how to achieve it

Re: listbox from and to date

sunny_talwar — Wed, 24 Aug 2016 20:12:02 GMT

See if this thread can guide you in the right direction:

Selecting Arbitrary Date Ranges

Re: listbox from and to date

Wed, 24 Aug 2016 20:21:41 GMT

this is for dates, need it for alphanumeric characters

Re: listbox from and to date

sunny_talwar — Wed, 24 Aug 2016 20:22:49 GMT

to and from alphanumeric characters? Can you share an example?

Re: listbox from and to date

Thu, 25 Aug 2016 01:44:49 GMT

there are store location codes when user select from and to store location and press button then store locations codes will selected in listbox in sorted order

Re: listbox from and to date

qlikviewwizard — Thu, 25 Aug 2016 07:31:56 GMT

Can you share sample application?

Re: listbox from and to date

Thu, 25 Aug 2016 08:53:21 GMT

Example you have below codes

RPOS1

L01RF

34GEF

9C3B

BDF21

BS040

DWKS008

TR97GH

4TYRS

if user selects From: 9C3B and To: L01RF then below should be selected and appear in below order in the Listbox

9C3B

BDF21

BS040

DWKS008

L01RF

Re: listbox from and to date

Sat, 27 Aug 2016 05:33:56 GMT

Can someone suggest on above?

Re: listbox from and to date

rwunderlich — Sat, 27 Aug 2016 06:06:14 GMT

Can they select from value and to value in the listbox while holding the shift key?

-Rob

Re: listbox from and to date

ToniKautto — Sat, 27 Aug 2016 06:20:55 GMT

I am sorry but that example makes no sense at all to me. You probably need to provide a lot more information and details for anyone to be able to give you guidance on this. If you provide a sample QVW it is also more likely, that someone can give more detailed advice.

I do not understand the data in your example. It is clearly codes, but what does it represent? Physical stores? Can you describe why the selection From: 9C3B and To: L01RF returns the result you expect? Are these stores that are geographically located between the selections, or what is the relation that leads this to be the answer?

Re: listbox from and to date

rwunderlich — Sun, 28 Aug 2016 09:26:08 GMT

Toni,

I think the selected values are the range between the selections when the values are sorted. The example does not include the 34GEF value, but that may have just been an oversight on the poster's part.

-Rob