Discussion board where members can get started with QlikView.
In my script I load one field with a range of values:
How can I set in the script, that values 1400001-1401009 will be excluded, but 1400004/01 + 1401009/1 will be loaded together with all other values ?
Thanks for your help.
Just write sql statement in the script It works
SQL SELECT NAme,Roll
FROM Supriya.dbo.Customer WHERE Roll NOT BETWEEN 9 AND 99 ;
You can try out the method used in the application.
There might be easier ways but at the moment I can think only of this
thank you, in my script WHERE [Field 1] NOT BETWEEN... does not work.
load [Field 1]
That looks great, thanks a lot, I will try it.
[Field 1]< 1400001 AND [Field 1]> 1400009
Hope this helps.