topic How to keep between condition for qvd file while loading? in QlikView

How to keep between condition for qvd file while loading?

jagannalla — Sat, 23 Jul 2011 04:51:42 GMT

Hi,

- I've a qvd file with with fields A,B,C.

- The field A contains the data from 1 to 100.

I written in the script to load A from 20 to 60 like following. But is there any solution to wite in different format to retrive the same result.

Load

A,B,C

from Table.qvd

where A >=20 and A <=60;

chriscammers — Sat, 23 Jul 2011 13:23:49 GMT

Sorry there is no "between" opertator like in SQL.

You could use inner join with an intervalmatch load but for what you are doing it would be completeely inefficient and a waste of effort.

What is your objection the the A >=X AND A <= Y syntax anyway?