Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

axnvazquez
New Contributor II

Max(date) in set analysis

Hi everyone ! I need help with this issue, because i had dates for each costumer sale, but in my table I need to get the sale of the last sale - max(date)

Captura.PNG

This is the function wich calculates the price for the las sale :

sum({$< _PITR_TYMTD={1}  , Origen_Dato={'Real'}, Mes=, Año=>} DCVC_TOTR_LOC_SIMP) /

Sum({$< _PITR_TYMTD={1}  , Origen_Dato={'Real'} ,Mes= , Año=>} DCVC_PESO)/20

But I need to set the last date, so i made the variable UltimaFecha =MAX({$<DCVC_TOTR_LOC_SIMP = {">=0"}, Mes=,Año=> } [%FECHA])

But i tried so many ways to set that date in the set analysis for the sum, but i cant display it .

I tried month, year, etc

Any help will be so helpfull !

Regards !

Tags (3)
5 Replies

Re: Max(date) in set analysis

You can use like below. Don't worry about Errors due to this is bug. May be next version they may released

sum({$< _PITR_TYMTD={1}  , $(UltimaFecha), Origen_Dato={'Real'}, Mes=, Año=>} DCVC_TOTR_LOC_SIMP) /

Sum({$< _PITR_TYMTD={1}  , $(UltimaFecha), Origen_Dato={'Real'} ,Mes= , Año=>} DCVC_PESO)/20

Re: Max(date) in set analysis

try this

I have assumed date format "MM/DD/YYYY".  Please give actual date format if field [%FECHA]

sum({$< _PITR_TYMTD={1}  , Origen_Dato={'Real'},[%FECHA]={"$(=date(MAX({$<DCVC_TOTR_LOC_SIMP = {">=0"}, Mes=,Año=> } [%FECHA]),'MM/DD/YYYY'))"}, Mes=, Año=>} DCVC_TOTR_LOC_SIMP) /

Sum({$< _PITR_TYMTD={1}  , Origen_Dato={'Real'} ,[%FECHA]={"$(=date(MAX({$<DCVC_TOTR_LOC_SIMP = {">=0"}, Mes=,Año=> } [%FECHA]),'MM/DD/YYYY'))"},Mes= , Año=>} DCVC_PESO)/20

axnvazquez
New Contributor II

Re: Max(date) in set analysis

Hi Anil ! thanks for the reply ! I tried the expression that you give, but is not displaying any value.

cap.PNG

Re: Max(date) in set analysis

Will you available to provide QVF file to check?

axnvazquez
New Contributor II

Re: Max(date) in set analysis

Anil, I can't provide de QVF file, sory i am not allowed to do that .

I tried to do something like this

sum({$< _PITR_TYMTD={1}  , [%FECHA]={$(=UltimaFecha)}>}, Origen_Dato={'Real'}, Mes=, Año=>} DCVC_TOTR_LOC_SIMP) /

Sum({$< _PITR_TYMTD={1}  ,[%FECHA]={$(=UltimaFecha)}>}, Origen_Dato={'Real'} ,Mes= , Año=>} DCVC_PESO)/20

But it doesn't work