Problem with Set Analisis

[#1]

Hi,

I am new in Qlikview, i have a problem with set analisis.

I need include a expression in set analisis but i can't to do that.

Expression --> =Text(Time((max(Intervalo_nro)-4)*1800/86400,'hh:mm'))

The expression is OK in a Text Object but in set analisis no

I try with,

Count ({< HORA_MIN={$(#=Text(Time((max(Intervalo_nro)-4)*1800/86400,'hh:mm')))}, Pais={"CHILE"} >} distinct(USERNAME))

Please help me!.

Thank!

[CELAMBARASAN]

Can you tell me th datatype of the field HORA_MIN? Is it formatted using time function?:

[#3]

the field HORA_MIN is type Text

[martin59 · Accepted solution]

Hello,

I suggest a solution in this post.

Doesn't it work ?

Martin Favier