Next Working day in Set

Fri, 23 May 2014 15:36:49 GMT

Hi Guys

Ina text box I am look to display when DTR_NEXT_REPRICING is either the next 2 working days and Currency = EUR,

When I literally write the set as

DTR_NEXT_REPRICING={'$(=date(today()+3))'}

It picks up the third date from today - but today is Friday I need it to pick up Monday and Tuesday, on Monday pick up Tuesday and Wednesday and so on,

Can anyone please help ?

Thanks

='Eur R/O available for SPOT '&

count({$<DTR_NEXT_REPRICING={'$(=lastworkdate(today(),2)'},DTR_CONTRACT_CCY={"*EUR*"}>} DTR_NEXT_REPRICING)

Re: Next Working day in Set

swuehl — Fri, 23 May 2014 17:52:57 GMT

Maybe

DTR_NEXT_REPRICING={'$(=lastworkdate(today(),2))','$(=lastworkdate(today(),3))'}

Re: Next Working day in Set

Mon, 26 May 2014 07:11:21 GMT

Thanks swuehl,

Yet again you've really helped me

topic Re: Next Working day in Set in QlikView

Next Working day in Set

Re: Next Working day in Set

Re: Next Working day in Set