Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Next Working day in Set

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

A

='Eur R/O available for SPOT '&

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe

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



View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe

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



Not applicable
Author

Thanks swuehl,

Yet again you've really helped me

A