Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

format time error in Set Analysis

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!

Screenshot_20.png

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

Capture.PNG

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

it should work like this:

Screenshot_21.png

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: format time error in Set Analysis

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)

View solution in original post

7 Replies
Highlighted

Re: format time error in Set Analysis

How about this:

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

Highlighted
MVP
MVP

Re: format time error in Set Analysis

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)



Dates in Set Analysis

The Little Equals Sign

The Magic of Dollar Expansions

The Magic of Variables

Highlighted
Esteemed Contributor III

Re: format time error in Set Analysis

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,

V.

Highlighted
Esteemed Contributor III

Re: format time error in Set Analysis

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

Highlighted
Not applicable

Re: format time error in Set Analysis

it doesn´t work 😕

Highlighted
Not applicable

Re: format time error in Set Analysis

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)

Highlighted
Not applicable

Re: format time error in Set Analysis

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)

View solution in original post