Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Boa tarde Senhores(as)
Gostaria de saber como posso somar os valores da maior data encontrada isso em uma expressão no QlikSense.
eu tentei algo desse tipo:
IF(Max({<valor={"*"}>}DATA)=DATA,SUM(valor))
Olá @paulo_chiovetto, I think you can use something like:
Sum({<DATA={'$(=Max(DATA))'}>} valor)
You will sum only rows where your date is the max date. Maybe you need to use Date() function to format your date, depending on your settings. In that case, it will be something like:
Sum({<DATA={'$(=Date(Max(DATA), 'DD/MM/YYYY'))'}>} valor)
JG
sum(<{Data={"$(=Max(Data))"}>}valor)
Geralmente faço dessa forma.
Olá @paulo_chiovetto, I think you can use something like:
Sum({<DATA={'$(=Max(DATA))'}>} valor)
You will sum only rows where your date is the max date. Maybe you need to use Date() function to format your date, depending on your settings. In that case, it will be something like:
Sum({<DATA={'$(=Date(Max(DATA), 'DD/MM/YYYY'))'}>} valor)
JG