topic Re: format time error in Set Analysis in QlikView

format time error in Set Analysis

Tue, 19 Jul 2016 17:59:44 GMT

Hi,

I'm trying to get the maximum value on the date using Set Analysis.

first y created a variable:

Date(MAX(Date(FECHA_PL)),'DD/MM/YYYY')

the result is OK!

Then I use this variable in Set Analysis but it returns Error

---------------

it should work like this:

sunny_talwar — Tue, 19 Jul 2016 18:28:24 GMT

How about this:

=Avg({<FECHA_PL = {'$(=Text(MaxFechaPL))'}>} ValorIndicator)

swuehl — Tue, 19 Jul 2016 18:29:22 GMT

Try

=Avg( {<FECHA_PL = {'$(MaxFechaPL)'}>} ValorIndicador)

edit: Assuming your variable is defined with a leading equal sign.

Or just use

=Avg( {<FECHA_PL = {'$(=Date(MAX(Date(FECHA_PL)),'DD/MM/YYYY'))'}>} ValorIndicador)

vishsaggi — Tue, 19 Jul 2016 19:13:44 GMT

May be an opening bracket after max like = Avg( {<FECHA_PL = {'$(Max(FechaPL))'}>} ValorIndicador)

Is there a fieldname MaxFechaPL, i doubt you missed a bracket here ? Correct me...

Thanks,

vishsaggi — Tue, 19 Jul 2016 19:16:22 GMT

Sorry Is MaxFechaPL is your variable name ? If Yes, follow what sunny and swuhel suggested.

Tue, 19 Jul 2016 20:43:54 GMT

it doesn´t work 😕

Tue, 19 Jul 2016 20:45:28 GMT

I tried everything and what worked for me was this

= AVG ({<FECHA_PL = {$ (= Chr (39) & Max (date (FECHA_PL, 'DD / MM / YYYY')) & Chr (39))}>} ValorIndicador)

Tue, 19 Jul 2016 20:46:13 GMT

I tried everything and what worked for me was this

= AVG ({<FECHA_PL = {$ (= Chr (39) & Max (date (FECHA_PL, 'DD / MM / YYYY')) & Chr (39))}>} ValorIndicador)