topic Re: Show data based on Alphanumeric range in QlikView

Show data based on Alphanumeric range

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to display selected data in listbox which consist of alphanumeric values based on values provided in input box

example I have below data with listbox LOCN and input box for From and To values with button

if user enters '1A2A' in From and '1A4A' in To and click on button then below values in LOCN listbox should be selected and data show in the report accordingly only for selected values

Data:

LOCN	RTN
1A1A	1023
1A1A	1027
1A1A	1028
1A2A	3123
1A2A	3124
1A2A	3289
1A3A	3290
1A4A	2111
1A4A	2312
1B1A	4421
1B1B	1245
1B1B	1287
1B2A	4231
1B2B	7652
1B3A	1628

Values selected in LOCN listbox

1A2A

1A3A

1A4A

Re: Show data based on Alphanumeric range

nagarjuna_kotha — Fri, 30 Sep 2016 04:44:01 GMT

I guess for combination of text and number data we can not filter on From and To.

Instead u u can use Input Box

Example:

Copy values from Excel or some other place and Paste in Input Box and thrn Select

It will give selected values only

Re: Show data based on Alphanumeric range

nagarjuna_kotha — Fri, 30 Sep 2016 04:51:38 GMT

Check attched,

Export your data to excel and Copy some and paste those it Input Box and press enter and then Select Filter.

It will select those you have entered by you.

I hope this may helps you.

-Nagarjun

Re: Show data based on Alphanumeric range

Fri, 30 Sep 2016 05:01:47 GMT

there should be two inputs From and To not one

Re: Show data based on Alphanumeric range

nagarjuna_kotha — Fri, 30 Sep 2016 05:10:13 GMT

For alfanumaric its not possible i thisnk.

This kind of scenario we require only one.

Check attached

-Nagarjun

Re: Show data based on Alphanumeric range

marcus_sommer — Fri, 30 Sep 2016 06:19:19 GMT

I think you will need to translate your alphanumerical values into unique numerical values and then you could apply a numeric range-matching from - to. For this you could create a new field like:

...

rangesum(

num(mid(LOCN, 1, 1)) * 100000 * ord(mid(LOCN, 2, 1)),

num(mid(LOCN, 3, 1)) * 100 * ord(mid(LOCN, 4, 1))) as LOCN_Numeric

...

There could be some more logic be needed to ensure that each LOCN creates an unique number and it's order regarding to the expected ranges is correct - but the approach itself should work.

- Marcus