topic Re: Problem with Set Analisis in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Set-Analisis/m-p/415505#M1157072 <HTML><HEAD></HEAD><BODY><P>Can you tell me th datatype of the field HORA_MIN? Is it formatted using time function?:</P></BODY></HTML> Fri, 11 Jan 2013 15:14:27 GMT CELAMBARASAN 2013-01-11T15:14:27Z Problem with Set Analisis https://community.qlik.com/t5/QlikView/Problem-with-Set-Analisis/m-p/415504#M1157071 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am new in Qlikview, i have a problem with set analisis.</P><P>I need include a expression in set analisis but i can't to do that.</P><P></P><P></P><P>Expression --&gt; <SPAN style="font-size: 10pt;">=<SPAN style="color: #0000ff;">Text</SPAN>(<SPAN style="color: #0000ff;">Time</SPAN>((<SPAN style="color: #0000ff;">max</SPAN>(<SPAN style="color: #800000;">Intervalo_nro</SPAN>)-4)*1800/86400,'hh:mm')) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">The expression is OK in a Text Object but in set analisis no</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I try with,</SPAN></P><P>Count<SPAN style="font-size: 10pt;"> ({&lt; <SPAN style="color: #800000;">HORA_MIN</SPAN>={<STRONG><EM style=": ; color: #808080;">$(#=Text(Time((max(Intervalo_nro)-4)*1800/86400,'hh:mm')))</EM></STRONG>}, <SPAN style="color: #800000;">Pais</SPAN>={<SPAN style="color: #800000;">"CHILE"</SPAN>} &gt;} <SPAN style="color: #0000ff;">distinct</SPAN>(<SPAN style="color: #800000;">USERNAME</SPAN></SPAN><SPAN style="font-size: 8pt;"><SPAN style="font-size: 10pt;">))</SPAN><BR /><BR /> </SPAN></P><P><SPAN style="font-size: 8pt;">Please help me!.</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Thank!</SPAN></P><P></P><P></P><P></P><P></P><P><SPAN style="color: #008000; font-size: 8pt;"> </SPAN></P></BODY></HTML> Fri, 11 Jan 2013 15:09:09 GMT https://community.qlik.com/t5/QlikView/Problem-with-Set-Analisis/m-p/415504#M1157071 2013-01-11T15:09:09Z Re: Problem with Set Analisis https://community.qlik.com/t5/QlikView/Problem-with-Set-Analisis/m-p/415505#M1157072 <HTML><HEAD></HEAD><BODY><P>Can you tell me th datatype of the field HORA_MIN? Is it formatted using time function?:</P></BODY></HTML> Fri, 11 Jan 2013 15:14:27 GMT https://community.qlik.com/t5/QlikView/Problem-with-Set-Analisis/m-p/415505#M1157072 CELAMBARASAN 2013-01-11T15:14:27Z Re: Problem with Set Analisis https://community.qlik.com/t5/QlikView/Problem-with-Set-Analisis/m-p/415506#M1157074 <HTML><HEAD></HEAD><BODY><P>the field HORA_MIN is type Text</P></BODY></HTML> Fri, 11 Jan 2013 15:28:50 GMT https://community.qlik.com/t5/QlikView/Problem-with-Set-Analisis/m-p/415506#M1157074 2013-01-11T15:28:50Z Re: Problem with Set Analisis https://community.qlik.com/t5/QlikView/Problem-with-Set-Analisis/m-p/415507#M1157075 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I suggest a solution in <A _jive_internal="true" href="https://community.qlik.com/message/299360#299360">this post</A>.</P><P></P><P>Doesn't it work ?</P><P></P><P>Martin Favier</P></BODY></HTML> Fri, 11 Jan 2013 15:32:07 GMT https://community.qlik.com/t5/QlikView/Problem-with-Set-Analisis/m-p/415507#M1157075 martin59 2013-01-11T15:32:07Z