topic Re: Range of alphabets between two list box in QlikView

Range of alphabets between two list box

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Range of alphabets between two list box

sunny_talwar — Wed, 28 Sep 2016 19:19:58 GMT

May be using this:

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

Re: Range of alphabets between two list box

Clever_Anjos — Wed, 28 Sep 2016 19:23:43 GMT

PFA a not optimized solution

Re: Range of alphabets between two list box

Wed, 28 Sep 2016 19:50:36 GMT

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'

Re: Range of alphabets between two list box

Clever_Anjos — Wed, 28 Sep 2016 20:06:21 GMT

Please try this instead

Re: Range of alphabets between two list box

MarcoWedel — Wed, 28 Sep 2016 20:51:27 GMT

Hi,

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

LOAD *,
    Money(Rand()*100) as sales
INLINE [
    StoreLocCode
    RPOS1
    L01RF
    34GEF
    9C3B
    BDF21
    BS040
    DWKS008
    TR97GH
    4TYRS
];

hope this helps

regards

Marco

Re: Range of alphabets between two list box

Thu, 29 Sep 2016 15:32:22 GMT

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

Re: Range of alphabets between two list box

MarcoWedel — Thu, 29 Sep 2016 19:32:23 GMT

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