- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
=/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Help mwe please!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it's done
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank Martin!!!!!
It's OK!