topic Re: expression in QlikView

expression

master_student — Mon, 01 Aug 2016 08:20:24 GMT

Hi everyone,

could you explain to me this expression please :

Age =dayStart(Today()) - dayStart([Date création] )

I need to get the working days between date creation and today, with excluding the days on vHol variable. here's my formula :

(NetWorkDays([ROW_ADDED_DTTM], [ROW_LASTMANT_DTTM]-1, $(vHol))

Is my expression correcte?

Thanks

vinieme12 — Mon, 01 Aug 2016 08:32:36 GMT

is your expression not working?

Anil_Babu_Samineni — Mon, 01 Aug 2016 08:53:51 GMT

While you are asking about expression, Try to share whole expression with out Variables?

jonathandienst — Mon, 01 Aug 2016 09:05:50 GMT

Looks OK, assuming that the the 2 fields are QV date values and that vHol is defined correctly. vHol should look like

Set vHol = '2016/01/01', '2016/05/01';

Test the expression without vHol; and if the number is correct, then add vHol and test again.