topic Re: Load statement "between" in QlikView

Load statement "between"

harjedalskok — Wed, 25 Nov 2020 16:16:04 GMT

Hi im struggling with a sql load statement

i would like to load the following

SELECT * FROM KONTO

WHERE (KontoNr BETWEEN 5900 AND 5999)

AND KontoNr BETWEEN 3000 AND 3010;

How do i create this in the load script.

Second question is how to sum a specific range / interval in a expression like below

Sum ( {$ <Booked.Year = {'2016'},Booked.Month = {apr,maj,jun},Konto = {<='5900' and >='5999'}>}, Konto = {<='3000' and >='3010'} Amount)

Thx in advance

Re: Load statement "between"

PrashantSangle — Thu, 09 Jun 2016 13:32:17 GMT

Hi,

I think you need OR here

SELECT * FROM KONTO

WHERE (KontoNr BETWEEN 5900 AND 5999)

OR KontoNr BETWEEN 3000 AND 3010;

REgards,

Re: Load statement "between"

PrashantSangle — Thu, 09 Jun 2016 13:35:00 GMT

For 2nd query try like

Sum ( {$ <Booked.Year = {'2016'},Booked.Month = {apr,maj,jun},Konto = {<=5900 >=5999}>+<Booked.Year = {'2016'},Booked.Month = {apr,maj,jun},Konto = {<=3000>=3010} >} Amount)

Regards

Re: Load statement "between"

trdandamudi — Thu, 09 Jun 2016 13:35:44 GMT

Qlikview doesn't have the 'Between' function, so you can use the below:

Data:

Load

From <Your Table Name >

Where KontoNr>=5900 and KontoNr <=5999 OR KontoNr >=3000 And KontoNr <=3010;

Re: Load statement "between"

sunny_talwar — Thu, 09 Jun 2016 14:16:57 GMT

Or even this should work:

Sum({$<Booked.Year = {'2016'}, Booked.Month = {apr,maj,jun}, Konto = {'<=5900 >=5999', '<=3000>=3010'}>} Amount)

Re: Load statement "between"

harjedalskok — Fri, 10 Jun 2016 07:17:07 GMT

Both Thirumala And Sunny T had correct answers.

Thx alot for fast respons.

Take care.