Set Analysis on Date

[jplozano]

Hi.

I have some problems with my set analysis. I have a date dimension called Fecha_Valor (DD/MM/YYYY) and a measure called Liquidez.

If i select the date 05/01/2018, i want the liquidez value for 04/01/2018. Im triying with this

sum({$ < Fecha_Valor={'$(=Only(Fecha_Valor)-1)'} > } Liquidez) but it doesn´t work.

If I try sum({$ < Fecha_Valor={'$(=Only(Fecha_Valor))'} > } Liquidez), i can see the value for the date filter.

Could you help me please?

Regards

[sunny_talwar · Accepted solution]

Try this

Sum({$<Fecha_Valor = {"$(=Date(Only(Fecha_Valor)-1))"}>} Liquidez)

[kfoudhaily]

define a variable first, in your variable editor:

v_GetLastDay = if(getselectedcount(Fecha_Valor)=0, today()-1, GetFieldSelections(Fecha_Valor)-1)

I have added the condition to select automatically yesterday when no date is selected in fetch_valor but I would have prefered doing that in the master calendar date field because Fecha_Valor might be not continuous.

then your expression should be:

sum($<Fecha_Valor{"=$(v_GetLastDay)"} = Liquidez)

regards,

[jplozano]

this is the solution... What is the diference between " and ' in Set Analysis?

[sunny_talwar]

Check them out here

Quotes in Set Analysis