Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rxp03570
Contributor

QVD Where condition for between values

Hi,

I'm trying load a qvd, but I want to limit the accounts to only pick account between 1 and 100, Can some one help me with the correct logic.

For Eg:

Load * from

C:\Users\draab\Documents\Data_Trans.qvd]

(qvd) Where AccountID ?????.

Thanks,

Rahul

1 Solution

Accepted Solutions
qlikmeplease
Contributor III

Re: QVD Where condition for between values

WHERE AccountID >= 1 and AccountID <= 100

3 Replies
qlikmeplease
Contributor III

Re: QVD Where condition for between values

WHERE AccountID >= 1 and AccountID <= 100

rajivmeher
Contributor

Re: QVD Where condition for between values

Hi Ruan

Shouldn't it be WHERE AccountID >= 1 and AccountID < 101


Otherwise the boundary values 1 and 100 will be excluded?


Regards

Rajiv.

qlikmeplease
Contributor III

Re: QVD Where condition for between values

Thanks Rajiv, missed that ! I have edited the post so he can easily copy.

Much appreciated.