topic Between two values in QlikView

Between two values

Tue, 15 Jan 2013 11:17:30 GMT

I've created CLE.ContractExpiringin_days, which is the Start Date less todays date, I would now like to show all those that have an expiry date within the next seven days, i.e. expiring in between 0 and 7 days but seem to have a problem when I use the below. Any thoughts?

([CLE.Period Inv_ Start Date] - Today()) as CLE.ContractExpiringin_days,

if (CLE.ContractExpiringin_days >=0 and <=7, 'Yes','No') as CLE.ContractExpiringin7days,

Re: Between two values

Tue, 15 Jan 2013 11:19:33 GMT

Hi Iain,

I think you have to change your expression to:

if (CLE.ContractExpiringin_days >=0 and CLE.ContractExpiringin_days<=7, 'Yes','No') as CLE.ContractExpiringin7days

Hope this works.

Vincent

Re: Between two values

Tue, 15 Jan 2013 11:40:15 GMT

Thanks Vincent, nearly worked. it created another problem that it didn't recognise CLE.ContractExpiringin_days, this was presumably because I'd only just created it in the script.

I took this out and recreated as below, which seems to have worked fine.

Thanks again

if ([CLE.Period Inv_ Start Date] - Today() >=0 and [CLE.Period Inv_ Start Date] - Today() <=7, 'Yes','No') as CLE.ContractExpiringin7days,