propose a default calculated value in a variable?

[chriscools]

Hello,

i have a table to fill in with variables, and 1 of the variables is the "number of working days left in the current month".

i use this to calcultate the remaining effort per day to reach our target set for that month.

when i use this i change this value every day and save this value.

But the other users open their qlikview in a mode that they can not save, to avoid that they would delete or change something in the qlikview file.

Now my question:

is it possible to have as default this number automatically calculated?

i don't want to put it in a hardcoded formula because we still want the possibility to change the value to calculate

the effect of adding working days . (working on holidyas, weekends,...)

i hope my question is explained clearly? 🙂

grtz,

chris

[hic]

One way could be to call the variable using

     $(=if(Len(variable)>0,variable,12))

Then it will use the variable value, if there is one. Otherwise use 12.

HIC

[chriscools]

Thanx for the reply,

but for what i want there should allways be a variable value that is:

     => precalculated : the remaining working days till the end of this month (how do i calculate this?

     => manually changed when a different value then the precalculated one is needed.

grtz,

chris

[chriscools · Accepted solution]

Hello,

i solved it with this expression in the variable:

NetWorkDays(  today(2), MonthEnd(Today()))

grtz,

Chris