Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Range of alphabets between two list box

Hi,

I want to display range of alphabets between two alphabets selected in list boxes

example : I have two listboxes From and To ,  If I select 'A' in From listbox and 'E' in To listbox then  result should display ABCDE in table

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Please try this instead

Capturar.PNG

View solution in original post

7 Replies
sunny_talwar

May be using this:

=Concat(Chr(Ord(From) + ValueLoop(0, Ord(To)-Ord(From))))


Capture.PNG

Clever_Anjos
Employee
Employee

PFA a not optimized solution

Not applicable
Author

Hi,

I do not want to concatenate the selected values in range ,  I want to show the data in report between selected alphabets range

example data in report should show between values 'A' to 'E'

Clever_Anjos
Employee
Employee

Please try this instead

Capturar.PNG

View solution in original post

MarcoWedel

Hi,

another solution using alternate states, set expressions and sample data from your thread listbox from and to date might be:

QlikCommunity_Thread_234549_Pic1.JPG

QlikCommunity_Thread_234549_Pic2.JPG

QlikCommunity_Thread_234549_Pic3.JPG

QlikCommunity_Thread_234549_Pic4.JPG

LOAD *,

    Money(Rand()*100) as sales

INLINE [

    StoreLocCode

    RPOS1

    L01RF

    34GEF

    9C3B

    BDF21

    BS040

    DWKS008

    TR97GH

    4TYRS

];

hope this helps

regards

Marco

Not applicable
Author

will it work for alphanumeric values?

example

If user enter From value  '13l1A'  and To value '14D1A ' in the input box  and then click on button then below  mentioned values should be selected as green in below Listbox

Values should selected as green:

13I1A            

13I2A            

13I2B           

14D1A

Listbox:

13H1B            

13I1A            

13I2A            

13I2B           

14D1A           

15D2A           

15H1A           

15H3A           

20C6A            

20D6B            

MarcoWedel

Your initial question was how to reduce a table based on selections in two list boxes.

Selecting field values based on inputs in input boxes is another question.

Please clarify.

thanks

regards

Marco