topic Re: filtering in QlikView https://community.qlik.com/t5/QlikView/filtering/m-p/390928#M1274463 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">=if(worksoft='A' and worksoft='B' , worksoft)</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Hope that helps</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Jonathan<BR /></SPAN></P></BODY></HTML> Thu, 01 Nov 2012 09:34:43 GMT jonathandienst 2012-11-01T09:34:43Z filtering https://community.qlik.com/t5/QlikView/filtering/m-p/390927#M1274461 <HTML><HEAD></HEAD><BODY><P>Hi friends , </P><P></P><P>i need to display only vlaues of A and B </P><P></P><P>i tried like this :</P><P></P><P>=if(worksoft='A' and 'B' , worksoft) , but it is not working, can anyone hlep me</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/filtering/m-p/390927#M1274461 janardhan 2026-01-26T18:19:17Z Re: filtering https://community.qlik.com/t5/QlikView/filtering/m-p/390928#M1274463 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">=if(worksoft='A' and worksoft='B' , worksoft)</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Hope that helps</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Jonathan<BR /></SPAN></P></BODY></HTML> Thu, 01 Nov 2012 09:34:43 GMT https://community.qlik.com/t5/QlikView/filtering/m-p/390928#M1274463 jonathandienst 2012-11-01T09:34:43Z Re: filtering https://community.qlik.com/t5/QlikView/filtering/m-p/390929#M1274465 <HTML><HEAD></HEAD><BODY><P>thanks Jonathan , i have tried both , but its&nbsp; no use</P></BODY></HTML> Thu, 01 Nov 2012 09:38:31 GMT https://community.qlik.com/t5/QlikView/filtering/m-p/390929#M1274465 janardhan 2012-11-01T09:38:31Z Re: filtering https://community.qlik.com/t5/QlikView/filtering/m-p/390930#M1274467 <HTML><HEAD></HEAD><BODY><P>Take a look at the attached.</P><P></P><P>The table I use is Alpha.</P><P></P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">concat</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Alpha</SPAN><SPAN style="font-size: 8pt;">,';')='A;B',1,0) </SPAN></P></BODY></HTML> Thu, 01 Nov 2012 12:04:30 GMT https://community.qlik.com/t5/QlikView/filtering/m-p/390930#M1274467 Bill_Britt 2012-11-01T12:04:30Z Re: filtering https://community.qlik.com/t5/QlikView/filtering/m-p/390931#M1274470 <HTML><HEAD></HEAD><BODY><P>Thanks Bill , i have already done this task</P></BODY></HTML> Thu, 01 Nov 2012 12:10:18 GMT https://community.qlik.com/t5/QlikView/filtering/m-p/390931#M1274470 janardhan 2012-11-01T12:10:18Z Re: filtering https://community.qlik.com/t5/QlikView/filtering/m-p/390932#M1274471 <HTML><HEAD></HEAD><BODY><P>So, can you post what you did?</P></BODY></HTML> Thu, 01 Nov 2012 12:22:01 GMT https://community.qlik.com/t5/QlikView/filtering/m-p/390932#M1274471 Bill_Britt 2012-11-01T12:22:01Z