Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)