intervalmatch with text.

[#1]

Hi All,

How to give @intervalmatch with text.Administrator

[Miguel_Angel_Baeyens]

Hi,

The short answer is you cannot. IntervalMatch() by definition works with numeric values and ranges of numeric values (see in the Reference Manual). Note that even dates are built as numeric in QlikView, and you can choose to display them as text or number.

Anyway, what do you exactly want to perform?

Miguel

[#3]

Hi There,

I'm trying to map a range of account numbers to a group.

For example:

Account Groups Exaample:

AccountCodeStartRange	AccountCodeEndRange	AccountType
R100000	R199999	Group 1
P200000	P299999	Group 2
Q300000	Q350000	Group 3
S350001	S350001	Group 4

Account Data

Account Code          Account Name

R100001                   Account 1

P100005                   Account 2

Q100010                    Account 3

S350001                    Account xxx

etc..

Although the ranges are wide there may only be 5 or 10 accounts in each range and they are frequently changing.

Can anyone think of an efficient way to map the accounts to the account group ranges in the load script?

ps The Account Groups are loaded from a spreadsheet and the Account Data is loaded from a separate database.

Thank you.

[#4]

Did you search the community? I found this as first link :

Intervalmatch using strings

Thanks,

Angad