Date condition in Qlivkiew SQL

Prabhu1204 — Wed, 25 Nov 2020 16:16:04 GMT

I am generating a qvd in Qlikview. Fetching details from DB.

Having a where condition like cal_month=12 and cal_days between 12 and 5.

How to achieve If I need to add on few cal months and cal days like cal_month = 5 and cal_days= 10 and 15.

I tired giving condition like where( cal_month = 12 and cal_days between 12 and 5) and ( cal_month = 5 and cal_days between 10 and 5) . Bit it seems to take more memory and it looks like wrong condition

Re: Date condition in Qlivkiew SQL

Prabhu1204 — Wed, 12 Feb 2020 06:35:20 GMT

Got it.. Giving both condition like below works,

where (cal_date =12 and cal_days between 10 and 15 OR cal_date= 5 and cal_days between 10 and 15)

topic Re: Date condition in Qlivkiew SQL in QlikView

Date condition in Qlivkiew SQL

Re: Date condition in Qlivkiew SQL