topic Re: Between Function in QV? in QlikView

Between Function in QV?

Anonymous — Thu, 09 Aug 2012 08:13:21 GMT

Hi - is there a way of replicating the between statement in sql when joining tables.

I need to append a value to a field which i can do with an if statement which will look something like

If (A = 1 and B <5000, 100, if(A=1 and B < 10000, 200, and on and on and on

In sql i would just join to a lookup table

FIELD 1 LOWE UPPER VALUE

A 0 5000 100

and use the between to return the correct value

Is there a way to do this in the qv load script (the end users of my work won't have oracle access, hence the need to find a QV scripting solution)

Thanks

Nandy

lironbaram — Thu, 09 Aug 2012 08:57:59 GMT

yes there is interval match

the script should look something like :

intervalmatch(B) load lower upper form tbl

that will create a table with every value of b inside his interval

Anonymous — Thu, 09 Aug 2012 12:25:35 GMT

Hi, thanks, managed to get something to work just about.