topic Last Working Day of Each Month in QlikView

Last Working Day of Each Month

vinicius_siquei — Wed, 08 Jan 2014 14:20:56 GMT

Hi,

I have one table and one chart in which I must present only the Value from the Last Working Day of Each Month.

I already have two columns in my Calendar table one with all the days of the month and another one only with working days. However I'm not being able to present only the data I need.

Could anyone please help me ?

Thanks

Re: Last Working Day of Each Month

swuehl — Wed, 08 Jan 2014 14:22:55 GMT

Maybe something like this, in a table chart with dimension Month:

=FirstSortedValue({<WorkingdayFlag = {1}>} Value, -Date)

Re: Last Working Day of Each Month

Wed, 08 Jan 2014 14:45:39 GMT

Hi,

Calculate the date of the nth working day of this month:

=LastWorkDate(MonthStart(Today()), n)

Regards,

Raja.

Re: Last Working Day of Each Month

Wed, 08 Jan 2014 14:48:07 GMT

Hi,

PFL,

http://community.qlik.com/thread/60001

Regards,

raja.

Re: Last Working Day of Each Month

vinicius_siquei — Wed, 08 Jan 2014 17:40:18 GMT

Thanks for all the answers, however I still coudn't make it work.

FirstSortedValue seems to be a good solution, but It's not working.

My dimension is Month

My expression is FirstSortedValue({<WorkingdayFlag = {1}>} Value, -Date)

I also tried to follow the other posts recommendation with no success.

Any Idea of how to obtain this information max Date per month where WorkDayFlag=1 ?

Thanks