topic Re: Listbox Filter in QlikView https://community.qlik.com/t5/QlikView/Listbox-Filter/m-p/1334767#M411863 <HTML><HEAD></HEAD><BODY><P>hi</P><P>Try this.</P><P>If(Flag= 0, Name)</P></BODY></HTML> Tue, 18 Apr 2017 13:18:02 GMT Anonymous 2017-04-18T13:18:02Z Listbox Filter https://community.qlik.com/t5/QlikView/Listbox-Filter/m-p/1334765#M411861 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to show list box (Name) values based on Flag column values like if Flag is 0 then Name corresponding to Flag=0 should only show in listbox. like -</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;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 122px;"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none; background-color: #bdd7ee;" width="70"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Name</STRONG></TD><TD style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black; background-color: #bdd7ee;" width="52"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Flag</STRONG></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Mahendra</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Rajiv</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Pranav</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">0</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Vaibhav</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>List box should show only -</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;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="70"><TBODY><TR><TD height="20" style="border: 0.5pt solid windowtext; border-image: none; background-color: #bdd7ee;" width="70"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">Name</STRONG></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Rajiv</SPAN></TD></TR><TR><TD height="20" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Pranav</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 18 Apr 2017 13:08:35 GMT https://community.qlik.com/t5/QlikView/Listbox-Filter/m-p/1334765#M411861 mahendragaur 2017-04-18T13:08:35Z Re: Listbox Filter https://community.qlik.com/t5/QlikView/Listbox-Filter/m-p/1334766#M411862 <HTML><HEAD></HEAD><BODY><P>like this??</P></BODY></HTML> Tue, 18 Apr 2017 13:15:36 GMT https://community.qlik.com/t5/QlikView/Listbox-Filter/m-p/1334766#M411862 Anonymous 2017-04-18T13:15:36Z Re: Listbox Filter https://community.qlik.com/t5/QlikView/Listbox-Filter/m-p/1334767#M411863 <HTML><HEAD></HEAD><BODY><P>hi</P><P>Try this.</P><P>If(Flag= 0, Name)</P></BODY></HTML> Tue, 18 Apr 2017 13:18:02 GMT https://community.qlik.com/t5/QlikView/Listbox-Filter/m-p/1334767#M411863 Anonymous 2017-04-18T13:18:02Z Re: Listbox Filter https://community.qlik.com/t5/QlikView/Listbox-Filter/m-p/1334768#M411864 <HTML><HEAD></HEAD><BODY><P>In the 'Field' select expression and use this:</P><P></P><P><IMG __jive_id="160391" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/160391_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P><SPAN style="font-size: 10pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 10pt;">If</SPAN><SPAN style="font-size: 10pt;">(</SPAN><SPAN style="color: #800000; font-size: 10pt;">Flag</SPAN><SPAN style="font-size: 10pt;"> = 0, </SPAN><SPAN style="color: #800000; font-size: 10pt;">Name</SPAN><SPAN style="font-size: 10pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">HTH</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Andy</SPAN></P></BODY></HTML> Tue, 18 Apr 2017 13:18:22 GMT https://community.qlik.com/t5/QlikView/Listbox-Filter/m-p/1334768#M411864 awhitfield 2017-04-18T13:18:22Z