Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
martin59
Specialist II
Specialist II

Hola,

I don't understand spanish but i can try to help you,

Could you try this expression :

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

Hope that helps you

Martin Favier

View solution in original post

6 Replies
martin59
Specialist II
Specialist II

Hola,

I don't understand spanish but i can try to help you,

Could you try this expression :

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

Hope that helps you

Martin Favier

View solution in original post

Not applicable
Author

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,

=/

martin59
Specialist II
Specialist II

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_TEXT

FROM Data.qvd (qvd);

And your Set Analysis will become

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

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

Martin Favier

Not applicable
Author

Help mwe please!

martin59
Specialist II
Specialist II

it's done

Not applicable
Author

Thank Martin!!!!!

It's OK!