topic Re: intervalmatch with text. in QlikView

intervalmatch with text.

Mon, 17 Feb 2014 11:39:12 GMT

Hi All,

How to give @intervalmatch with text.Administrator

Re: intervalmatch with text.

Miguel_Angel_Baeyens — Mon, 17 Feb 2014 11:47:46 GMT

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

Re: intervalmatch with text.

Mon, 17 Feb 2014 12:04:06 GMT

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.

Re: intervalmatch with text.

Mon, 17 Feb 2014 12:17:30 GMT

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

Intervalmatch using strings

Thanks,

Angad