topic How do I get a 'between' expression to work? in App Development

How do I get a 'between' expression to work?

Tue, 21 Mar 2017 15:27:37 GMT

Hi there,

I need to create an IF statement that contains a 'between' expression but I cant seem to get it to work. Basically I have a formula which is working out the no. of months since a booking date to now and I need it to only show me the entries have a No. of months since booking date between 9 and 12 months.

The formula I have to give me the no. of months is as follows,

((year(today(2))*12)+month(today(2))) - (((year([BookingDate.autoCalendar.Date])*12)+month([BookingDate.autoCalendar.Date])))

Can anyone help?

Thank you!

Re: How do I get a 'between' expression to work?

sunny_talwar — Tue, 21 Mar 2017 15:57:33 GMT

I don't think QlikView has a Between function... what is the exact expression you are using?

Re: How do I get a 'between' expression to work?

swuehl — Tue, 21 Mar 2017 16:02:20 GMT

Louisa, you would need to use two comparisons and a AND logical operator:

If( EXPRESSION >=9 and EXPRESSION <= 12, ....)

or if you check against distinct values, you can use a matching function:

If( Match( EXPRESSION, 9,10,11,12), ...