Discussion board where members can get started with Qlik Sense.
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.
Load * from
(qvd) Where AccountID ?????.
Go to Solution.
WHERE AccountID >= 1 and AccountID <= 100
Shouldn't it be WHERE AccountID >= 1 and AccountID < 101
Otherwise the boundary values 1 and 100 will be excluded?
Thanks Rajiv, missed that ! I have edited the post so he can easily copy.