Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, someone can help me, I am applying the following formula Concat(distinct {<Periodo={"=MonthName(Max(Periodo))"}>} Periodo,',') and I want only the maximum period, but the formula ignores the Max, I do not want the value of all the data but only those that are visualized in the table, since it could show an amount For years, quarter and months on a pivot table, thank you very much
Hi Jonathan, maybe with:
Concat(distinct {<Periodo={"$(=MonthName(Max(Periodo)))"}>} Periodo)
Why not only?:
MonthName(Max(Periodo))
You would need $ sign inside the element list -
Concat(distinct {<Periodo={"=$(=MonthName(Max(Periodo)))"}>} Periodo,',')
Thanks Ruben but it did not work, my main objective is to achieve something of this style count({<Periodo={"=$(=MonthName(Max(Periodo)))"}>} Periodo), because if I put in the analysis set '$ (= Max (Period))' it will bring me the highest value of all data
Thanks Digvijay but it did not work
Ensure that Periodo is a dual field generated out of date. If it is a text field then comparison might not work.
I created the Period field in the load script, however when placing the formula I get no value
My Code
Log:
LOAD
AutoNumber(Id_Recurso) as Id_Recurso,
MonthName(Log_Periodo) as Periodo,
Num(Log_Periodo) as #Periodo,
Year(Log_Periodo) as Año,
Month(Log_Periodo) as Mes,
Ceil(Num(Month(Log_Periodo))/3) as Quarter
FROM [lib://Acumulado/Log_Acumulado.qvd]
(qvd);
I tried on sample , and this expression worked for me.
=concat(distinct {<Periodo={'$(=Monthname(Max(Periodo)))'}>}Periodo,',')
Yes, but it only brings the last period of the highest year, the rest of the years does not show the corresponding, you could look at my qvf please, what I try is for a year to see the last month, for a quarter to see the last month of this And finally see month by month, thanks for your time