topic Selection on data range through slider in QlikView https://community.qlik.com/t5/QlikView/Selection-on-data-range-through-slider/m-p/434879#M162106 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">Dear All</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">I have straigh table including complaint_no,category,complaint_date,resolve_date,days_consumed</SPAN></P><P></P><P><STRONG style="font-size: 12pt;">dimension::</STRONG></P><P><SPAN style="font-size: 12pt;">complaint_no</SPAN></P><P><SPAN style="font-size: 12pt;">category </SPAN></P><P></P><P><STRONG style="font-size: 12pt;">Expression::</STRONG></P><P><SPAN style="font-size: 12pt;">compalint_date = min(comp_date)</SPAN></P><P><SPAN style="font-size: 12pt;">resolve_date = max(status_date)&nbsp; (beacause compalaint arrive in different status on diffrenet dates but max date means a final/resolving status)</SPAN></P><P><SPAN style="font-size: 12pt;">days_conusmed=round(max(staus_date)-min(comp_date))</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">it give a proper table as i want....</SPAN></P><P><SPAN style="font-size: 12pt;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt;">now i want to show a slider on the days consumed so selection can b made on days (single or multiple values)..................</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">how to resolve this.. or any other advice other then slider???</SPAN></P><P><SPAN style="font-size: 12pt;">when i give <SPAN style="font-size: 16px;">round(max(staus_date)-min(comp_date))</SPAN> this to slide no scale... becsuse may b aggr required.</SPAN></P><P><SPAN style="font-size: 12pt;">but i m not great at it kindly help<BR /></SPAN></P></BODY></HTML> Thu, 14 Feb 2013 06:49:51 GMT 2013-02-14T06:49:51Z Selection on data range through slider https://community.qlik.com/t5/QlikView/Selection-on-data-range-through-slider/m-p/434879#M162106 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">Dear All</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">I have straigh table including complaint_no,category,complaint_date,resolve_date,days_consumed</SPAN></P><P></P><P><STRONG style="font-size: 12pt;">dimension::</STRONG></P><P><SPAN style="font-size: 12pt;">complaint_no</SPAN></P><P><SPAN style="font-size: 12pt;">category </SPAN></P><P></P><P><STRONG style="font-size: 12pt;">Expression::</STRONG></P><P><SPAN style="font-size: 12pt;">compalint_date = min(comp_date)</SPAN></P><P><SPAN style="font-size: 12pt;">resolve_date = max(status_date)&nbsp; (beacause compalaint arrive in different status on diffrenet dates but max date means a final/resolving status)</SPAN></P><P><SPAN style="font-size: 12pt;">days_conusmed=round(max(staus_date)-min(comp_date))</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">it give a proper table as i want....</SPAN></P><P><SPAN style="font-size: 12pt;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt;">now i want to show a slider on the days consumed so selection can b made on days (single or multiple values)..................</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">how to resolve this.. or any other advice other then slider???</SPAN></P><P><SPAN style="font-size: 12pt;">when i give <SPAN style="font-size: 16px;">round(max(staus_date)-min(comp_date))</SPAN> this to slide no scale... becsuse may b aggr required.</SPAN></P><P><SPAN style="font-size: 12pt;">but i m not great at it kindly help<BR /></SPAN></P></BODY></HTML> Thu, 14 Feb 2013 06:49:51 GMT https://community.qlik.com/t5/QlikView/Selection-on-data-range-through-slider/m-p/434879#M162106 2013-02-14T06:49:51Z Re: Selection on data range through slider https://community.qlik.com/t5/QlikView/Selection-on-data-range-through-slider/m-p/434880#M162107 <HTML><HEAD></HEAD><BODY><P>Hi, have you tried putting:</P><P> AGGR( round(max(staus_date)-min(comp_date)) ,complaint_no,category)</P><P></P><P>in your slider?</P></BODY></HTML> Thu, 14 Feb 2013 09:28:45 GMT https://community.qlik.com/t5/QlikView/Selection-on-data-range-through-slider/m-p/434880#M162107 sbaldwin 2013-02-14T09:28:45Z Re: Selection on data range through slider https://community.qlik.com/t5/QlikView/Selection-on-data-range-through-slider/m-p/434881#M162108 <HTML><HEAD></HEAD><BODY><P>ya i tried but it is mis behaving..... working fine on single selection but i am not able to select data range....</P><P></P><P>need more post</P></BODY></HTML> Fri, 15 Feb 2013 06:17:24 GMT https://community.qlik.com/t5/QlikView/Selection-on-data-range-through-slider/m-p/434881#M162108 2013-02-15T06:17:24Z Re: Selection on data range through slider https://community.qlik.com/t5/QlikView/Selection-on-data-range-through-slider/m-p/434882#M162109 <HTML><HEAD></HEAD><BODY><P>can u upload your sample application.</P></BODY></HTML> Fri, 15 Feb 2013 06:46:21 GMT https://community.qlik.com/t5/QlikView/Selection-on-data-range-through-slider/m-p/434882#M162109 sushil353 2013-02-15T06:46:21Z