Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Prabhu1204
Creator
Creator

Date condition in Qlivkiew SQL

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

-Prabhu
Labels (1)
1 Solution

Accepted Solutions
Prabhu1204
Creator
Creator
Author

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)

-Prabhu

View solution in original post

1 Reply
Prabhu1204
Creator
Creator
Author

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)

-Prabhu