topic Re: Where clasue for range values in QlikView

Where clasue for range values

Fri, 20 Mar 2015 10:12:21 GMT

Hi , I would like to get data between '2015001' and '2015012' from data base,,, what would be the best way to write it in where clause.

As you see I am using MATCH statement, but I think it can be written in a better way

SQL

SELECT * FROM /BIC/AO2HIPLPA00 //$(vTable)
WHERE MATCH (FISCPER, '2015001','2015002','2015003','2015004','2015005','2015006','2015007','2015008','2015009','2015010','2015011','2015012') // $(Period) // 001/2015 012/2015
AND DISTR_CHAN = '99'

Re: Where clasue for range values

Roop — Fri, 20 Mar 2015 10:14:31 GMT

Replace the where statement with:

where FISCPER >= '2015001' and FISCPER <= '2015012' AND DISTR_CHAN = '99'

Re: Where clasue for range values

Gysbert_Wassenaar — Fri, 20 Mar 2015 10:15:07 GMT

Try where FISCPER between '2015001' and '2015012'

Re: Where clasue for range values

Fri, 20 Mar 2015 10:17:16 GMT

I would like to include both ends so can it be FISCPER >= '2015001' and FISCPER <= '2015012'

Re: Where clasue for range values

Gabriel — Fri, 20 Mar 2015 11:18:41 GMT

Hi,

WHERE date >= '2015001' AND

date <= '2015012'

Re: Where clasue for range values

buzzy996 — Fri, 20 Mar 2015 13:41:39 GMT

I preferred Gysbert approach.