topic FILTER DATA ACCORDING TO SLIDER OBJECT in QlikView https://community.qlik.com/t5/QlikView/FILTER-DATA-ACCORDING-TO-SLIDER-OBJECT/m-p/32575#M5511 <HTML><HEAD></HEAD><BODY><P>Hi Folks ...</P><P></P><P>I want to filter data based on the slider object set point</P><P></P><P>Here I'm having data of employees with department,date,time </P><P>Now my requirement is to display the list of employees by setting the time in the slider </P><P></P><P>PFA. </P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P><A href="https://community.qlik.com/qlik-users/26418">tresesco</A>‌</P></BODY></HTML> Mon, 30 Apr 2018 05:13:12 GMT kakani87 2018-04-30T05:13:12Z FILTER DATA ACCORDING TO SLIDER OBJECT https://community.qlik.com/t5/QlikView/FILTER-DATA-ACCORDING-TO-SLIDER-OBJECT/m-p/32575#M5511 <HTML><HEAD></HEAD><BODY><P>Hi Folks ...</P><P></P><P>I want to filter data based on the slider object set point</P><P></P><P>Here I'm having data of employees with department,date,time </P><P>Now my requirement is to display the list of employees by setting the time in the slider </P><P></P><P>PFA. </P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P><A href="https://community.qlik.com/qlik-users/26418">tresesco</A>‌</P></BODY></HTML> Mon, 30 Apr 2018 05:13:12 GMT https://community.qlik.com/t5/QlikView/FILTER-DATA-ACCORDING-TO-SLIDER-OBJECT/m-p/32575#M5511 kakani87 2018-04-30T05:13:12Z Re: FILTER DATA ACCORDING TO SLIDER OBJECT https://community.qlik.com/t5/QlikView/FILTER-DATA-ACCORDING-TO-SLIDER-OBJECT/m-p/32576#M5512 <HTML><HEAD></HEAD><BODY><P>Try this expression.</P><P></P><P>Time(If(v_lt_start&lt;=min(first_start_time - Floor(first_start_time)),min(first_start_time - Floor(first_start_time))))</P><P></P><P>Also remove the other expression i.e 1.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 30 Apr 2018 05:23:07 GMT https://community.qlik.com/t5/QlikView/FILTER-DATA-ACCORDING-TO-SLIDER-OBJECT/m-p/32576#M5512 kaushiknsolanki 2018-04-30T05:23:07Z Re: FILTER DATA ACCORDING TO SLIDER OBJECT https://community.qlik.com/t5/QlikView/FILTER-DATA-ACCORDING-TO-SLIDER-OBJECT/m-p/32577#M5513 <HTML><HEAD></HEAD><BODY><P>Thanks a bunch <STRONG>Kaushik ...</STRONG></P><P>This worked </P></BODY></HTML> Mon, 30 Apr 2018 05:37:08 GMT https://community.qlik.com/t5/QlikView/FILTER-DATA-ACCORDING-TO-SLIDER-OBJECT/m-p/32577#M5513 kakani87 2018-04-30T05:37:08Z Re: FILTER DATA ACCORDING TO SLIDER OBJECT https://community.qlik.com/t5/QlikView/FILTER-DATA-ACCORDING-TO-SLIDER-OBJECT/m-p/32578#M5514 <HTML><HEAD></HEAD><BODY><P>perfect..</P><P></P><P>cheers&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 30 Apr 2018 05:39:53 GMT https://community.qlik.com/t5/QlikView/FILTER-DATA-ACCORDING-TO-SLIDER-OBJECT/m-p/32578#M5514 kaushiknsolanki 2018-04-30T05:39:53Z