topic Re: Display excluded values? in QlikView https://community.qlik.com/t5/QlikView/Display-excluded-values/m-p/931654#M322024 <HTML><HEAD></HEAD><BODY><P>check this, will get the answer:</P><P></P><P><A href="https://community.qlik.com/thread/163744">how to show the value "from date" to "to date"</A></P><P></P><P><A href="https://community.qlik.com/thread/149528">"from" and "to" date display....</A></P><P></P><P><A href="https://community.qlik.com/thread/36922">The use of variables to filter a date range</A></P><P></P><P><A href="https://community.qlik.com/thread/67712">Selecting Arbitrary Date Ranges</A></P></BODY></HTML> Tue, 15 Dec 2015 11:58:26 GMT Anonymous 2015-12-15T11:58:26Z Display excluded values? https://community.qlik.com/t5/QlikView/Display-excluded-values/m-p/931653#M322023 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I&nbsp; have a table like as below. If I select first date(<SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/5/1998</SPAN>) and last date (<SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/16/1998</SPAN>) then I want to display the data between the those two dates.</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN></P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 185px;"><TBODY><TR><TD height="20" style="border: 0px black; border-image: none;" width="67"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">PRODUCT</STRONG></TD><TD style="border: 0px black; border-image: none;" width="43"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">SALES</STRONG></TD><TD style="border: 0px black; border-image: none;" width="75"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DATE</STRONG></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PENS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">200</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/5/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">PENCILS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">500</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/6/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BALL PENS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">600</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/7/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">INK TINS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">700</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/8/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">HAND KEYS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">850</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/9/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BOOKS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">6400</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;"> 2/10/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BELLS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">450</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/11/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">BAGS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/12/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">SHOES</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/13/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">SANDALS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">15000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/14/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">LAPTOPS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">3000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/15/1998</SPAN></TD></TR><TR><TD height="20" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">KEYBOARDS</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4000</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2/16/1998</SPAN></P><P></P></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P>kindly help on this .Thanks</P><P></P><P>Regards,</P><P>Chirumamilla</P></BODY></HTML> Tue, 15 Dec 2015 11:18:48 GMT https://community.qlik.com/t5/QlikView/Display-excluded-values/m-p/931653#M322023 2015-12-15T11:18:48Z Re: Display excluded values? https://community.qlik.com/t5/QlikView/Display-excluded-values/m-p/931654#M322024 <HTML><HEAD></HEAD><BODY><P>check this, will get the answer:</P><P></P><P><A href="https://community.qlik.com/thread/163744">how to show the value "from date" to "to date"</A></P><P></P><P><A href="https://community.qlik.com/thread/149528">"from" and "to" date display....</A></P><P></P><P><A href="https://community.qlik.com/thread/36922">The use of variables to filter a date range</A></P><P></P><P><A href="https://community.qlik.com/thread/67712">Selecting Arbitrary Date Ranges</A></P></BODY></HTML> Tue, 15 Dec 2015 11:58:26 GMT https://community.qlik.com/t5/QlikView/Display-excluded-values/m-p/931654#M322024 Anonymous 2015-12-15T11:58:26Z Re: Display excluded values? https://community.qlik.com/t5/QlikView/Display-excluded-values/m-p/931655#M322025 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>You can use the slider object like this ,</P><P><IMG alt="Slider.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109070_Slider.PNG" style="height: 249px; width: 620px;" /></P><P></P><P>Hope this helps,</P><P>PFA,</P><P>Regards,</P><P>Hirish</P></BODY></HTML> Tue, 15 Dec 2015 12:08:38 GMT https://community.qlik.com/t5/QlikView/Display-excluded-values/m-p/931655#M322025 HirisH_V7 2015-12-15T12:08:38Z Re: Display excluded values? https://community.qlik.com/t5/QlikView/Display-excluded-values/m-p/931656#M322026 <HTML><HEAD></HEAD><BODY><P>Try this acttach file </P><P>hope this help you</P><P></P><P>Regards</P><P>Ahmar</P></BODY></HTML> Tue, 15 Dec 2015 12:11:39 GMT https://community.qlik.com/t5/QlikView/Display-excluded-values/m-p/931656#M322026 ahmar811 2015-12-15T12:11:39Z