topic Re: Clarification in the List box in QlikView https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440976#M164397 <HTML><HEAD></HEAD><BODY><P>Hey Check the attachment</P></BODY></HTML> Wed, 19 Dec 2012 04:19:25 GMT sivarajs 2012-12-19T04:19:25Z Clarification in the List box https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440971#M164392 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>As I have four inline attributes like in the below, I would like to create a list box that should not show Mar in the list box and rest should show.</P><P></P><P>How to block the month Mar.</P><P></P><P></P><P>Load * Inline[</P><P>Month</P><P>Jan</P><P>Feb</P><P>Mar</P><P>Apr] ;</P><P></P><P>Regards</P><P></P><P>Chriss</P></BODY></HTML> Mon, 17 Dec 2012 05:53:42 GMT https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440971#M164392 2012-12-17T05:53:42Z Re: Clarification in the List box https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440972#M164393 <HTML><HEAD></HEAD><BODY><P>In Listbox expression use if(not wildmatch(Month,'*Mar*'),Month)</P></BODY></HTML> Mon, 17 Dec 2012 06:07:16 GMT https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440972#M164393 sivarajs 2012-12-17T06:07:16Z Re: Clarification in the List box https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440973#M164394 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this code.</P><P></P><P>T_Month:</P><P>Load&nbsp; </P><P> IF (Month= 'Mar',Null(),Month) AS Month</P><P>Resident TableName;</P><P></P><P>Regards,</P><P>Nirav Bhimani</P></BODY></HTML> Mon, 17 Dec 2012 06:13:07 GMT https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440973#M164394 nirav_bhimani 2012-12-17T06:13:07Z Re: Clarification in the List box https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440974#M164395 <HTML><HEAD></HEAD><BODY><P>Hello Sivaraj and Nirav, </P><P></P><P>Owesome, it works...</P><P></P><P>Regrads</P><P></P><P>Chirss</P></BODY></HTML> Mon, 17 Dec 2012 06:45:20 GMT https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440974#M164395 2012-12-17T06:45:20Z Re: Clarification in the List box https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440975#M164396 <HTML><HEAD></HEAD><BODY><P>Hi <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Sivaraj </SPAN> &amp; <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Chriss</SPAN>,</P><P></P><P>Can you please share a demo file of the expression which is working in above case.</P><P>In my case ur expression is not working.</P><P></P><P>Regards,</P><P>Nirav Bhimani</P></BODY></HTML> Tue, 18 Dec 2012 12:20:22 GMT https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440975#M164396 nirav_bhimani 2012-12-18T12:20:22Z Re: Clarification in the List box https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440976#M164397 <HTML><HEAD></HEAD><BODY><P>Hey Check the attachment</P></BODY></HTML> Wed, 19 Dec 2012 04:19:25 GMT https://community.qlik.com/t5/QlikView/Clarification-in-the-List-box/m-p/440976#M164397 sivarajs 2012-12-19T04:19:25Z