Last Working Day of Each Month

[vinicius_siquei]

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

[swuehl]

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

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

[#3]

Hi,

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

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

Regards,

Raja.

[#4]

Hi,

PFL,

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

Regards,

raja.

[vinicius_siquei]

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