# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted
Not applicable

## Expresiones en Set Analisis

Hola,

Soy nuevo en Qlikview y estoy intentando hacer un documento pero he tenido algunos problemas con set analisis

Necesito incluir dentro del set analisis una expresion, lo he intentado y me arroja 0 cuando me deberia arrojar otro resultado

La expresion es la siguiente  --> =Text(Time((max(Intervalo_nro)-4)*1800/86400,'hh:mm'))

Al copiar la expresion en una objeto de texto me arroja el intervalo que necesito mostrar pero al copiarlo al set analisis no realiza el filtro.

En la tabla he intentado con lo siguiente,

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

Porfavor ayudenme,!

Muchas Gracias

Tags (4)
1 Solution

Accepted Solutions
Highlighted
Specialist II

## Re: Expresiones en Set Analisis

Hola,

Could you try this expression :

Hope that helps you

Martin Favier

6 Replies
Highlighted
Specialist II

## Re: Expresiones en Set Analisis

Hola,

Could you try this expression :

Hope that helps you

Martin Favier

Highlighted
Not applicable

## Re: Expresiones en Set Analisis

Martin,

Thank, but the expression is bad =/,

The problem is the expression  =Text(Time((max(Intervalo_nro)-4)*1800/86400,'hh:mm'))) is ok in a object text but in set analisis give me a bad result,

=/

Highlighted
Specialist II

## Re: Expresiones en Set Analisis

Ok,

And have you tried to convert your HORA_MIN field in the LOAD scrip ?

You can do something like this :

 LOAD ...,     HORA_MIN,     Text(HORA_MIN) as HORA_MIN_TEXTFROM Data.qvd (qvd);

And your Set Analysis will become

However, you can make it easier with two fields, HORA and MIN, and use them in Set Analysis.

Martin Favier

Highlighted
Not applicable

Highlighted
Specialist II

it's done

Not applicable

## Re: Expresiones en Set Analisis

Thank Martin!!!!!

It's OK!