Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

joshuagoh
New Contributor

Load data if account number is within range of values

Hi all,

I'm trying to load the following excel:

AccountNumber | Balance

1000                   |$10

2001                   |$10

1002                   |$10

3000                   |$10

1099                   |$10


and I would like to load only the accounts that fall between 1000 and 1999.


Is there a way I can put an IF statement in the load?


Thank you!



1 Solution

Accepted Solutions

Re: Load data if account number is within range of values

Hi Josh,

Try,

Load ..

From

Excel where AccountNumber > 999 and AccountNumber < 2000;

2 Replies

Re: Load data if account number is within range of values

Hi Josh,

Try,

Load ..

From

Excel where AccountNumber > 999 and AccountNumber < 2000;

OmarBenSalem
Esteemed Contributor

Re: Load data if account number is within range of values

load *

from souce where AccountNumber >=1000 and AccountNumber <=1999;

Community Browser