Change date field values dynamically

[Anusha30]

Hi All,

I need help to create a date field where the values will change dynamically based on today date.

You can find the reference data in attached excel. In excel data we are calculating Date field based on some calculations same thing i want to achieve in qliksense as well. 

Please help me to solve this issue it is very urgent requirement.

with the help of I(formula : TODAY()-WEEKDAY(TODAY())+1-7) field we are calculating Date filed.

[vinieme12]

Hi, can you explain why only the first date offsets by 8 days but the rest only by 7 days?

[Anusha30]

@vinieme12  I am not sure on this. Already in excel they are using this condition.

[vinieme12]

please get some clarity on the business reasons, to me it looks like we just need the first weekday ;

what is the frequency of changing the date in this dataset? and what is the actual task here?