topic Re: Max(date) in set analysis in QlikView

Max(date) in set analysis

axnvazquez — Tue, 20 Jun 2017 01:19:38 GMT

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)

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 !

Re: Max(date) in set analysis

Anil_Babu_Samineni — Tue, 20 Jun 2017 06:43:10 GMT

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

Kushal_Chawda — Tue, 20 Jun 2017 07:39:44 GMT

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

Re: Max(date) in set analysis

axnvazquez — Tue, 20 Jun 2017 13:15:36 GMT

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

Re: Max(date) in set analysis

Anil_Babu_Samineni — Tue, 20 Jun 2017 15:17:21 GMT

Will you available to provide QVF file to check?

Re: Max(date) in set analysis

axnvazquez — Wed, 21 Jun 2017 14:06:20 GMT

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