Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

listbox from and to date

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

10 Replies

Re: listbox from and to date

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

Selecting Arbitrary Date Ranges

Not applicable

Re: listbox from and to date

this is for dates, need it for alphanumeric characters

Re: listbox from and to date

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

Not applicable

Re: listbox from and to date

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

Arjunarao
Honored Contributor II

Re: listbox from and to date

Can you share sample application?

Not applicable

Re: listbox from and to date

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

Not applicable

Re: listbox from and to date

Can someone suggest on above?

MVP & Luminary
MVP & Luminary

Re: listbox from and to date

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

-Rob

Employee
Employee

Re: listbox from and to date

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?