Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rxp03570
Creator
Creator

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
Anonymous
Not applicable

WHERE AccountID >= 1 and AccountID <= 100

View solution in original post

3 Replies
Anonymous
Not applicable

WHERE AccountID >= 1 and AccountID <= 100

rajivmeher
Creator
Creator

Hi Ruan

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


Otherwise the boundary values 1 and 100 will be excluded?


Regards

Rajiv.

Anonymous
Not applicable

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

Much appreciated.