topic propose a default calculated value in a variable? in QlikView

propose a default calculated value in a variable?

chriscools — Fri, 15 Nov 2013 08:22:38 GMT

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 — Fri, 15 Nov 2013 08:58:00 GMT

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 — Fri, 15 Nov 2013 09:56:27 GMT

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 — Fri, 15 Nov 2013 14:05:34 GMT

Hello,

i solved it with this expression in the variable:

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

grtz,

Chris