Help with Expression Date and Table

[antoniodneto]

Hi Guys,

Could you help me with a new one?

I have a table with my dimensions: COD,GRUPO,VA,SCAN,DATE_VA and my measure RISK

What I need to do is I have two DATE FIELDS, DATE_VA and DATE

My field DATE has the one value per month: 01/01/2019,01/12/2018,01/11/2018......

But my DATE_VA has the values per day: 31/01/2019,30/01/2019,29/01/2019.....

In my table I want to show for example when I choose in my DATE 01/11/2018 tha table with DATE_VA should return all the valus <= then YearMonth of DATE.

For example, If I select 01/11/2018 so YearMonth is 11/2018 the DATE_VA needs to return all the values <= 11/2018.

My expression is =Sum({$<SORTDIM2={"=Rank(Sum(RISCO_TOTAL))"}>} RISCO_TOTAL)

I don't know if I was clearly, but lol.

Tks a lot!!

[sunny_talwar]

Not entirely sure, but may be this

=Sum({$<SORTDIM2 = {"=Rank(Sum({<DATE_VA = {"$(='<=' & MonthStart(Max(DATE)))"}>} RISCO_TOTAL))"}, DATE_VA = {"$(='<=' & MonthStart(Max(DATE)))"}>} RISCO_TOTAL)

[antoniodneto]

Hi Sunny,

Is not working with this expression when I select 11/2018 that returns me in DATE_VA values with 11/2019, where supposed to return the all values <= 11/2018.

[sunny_talwar]

Would you be able to share a sample where you are trying to do this?

[antoniodneto]

Sunny, my company blocked the acess to QMC, I'm not able to export.