topic Re: Filtering the Data in QlikView https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996376#M974058 <HTML><HEAD></HEAD><BODY><P>What is your question?</P></BODY></HTML> Tue, 08 Sep 2015 14:52:56 GMT m_woolf 2015-09-08T14:52:56Z Filtering the Data https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996375#M974057 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/23109">jagan</A>‌ <A href="https://community.qlik.com/qlik-users/93351">vinay_bangari</A>‌</P><P></P><P>Hi Experts,</P><P>I'm trying to filter the data by the LOB ID. Please find the attached screen shot.</P><P>Thanks in advance.</P><P></P><P><IMG __jive_id="98293" alt="FlatFiles Members.png" class="jive-image image-1" src="/legacyfs/online/98293_FlatFiles Members.png" style="width: 620px; height: 297px;" /></P></BODY></HTML> Tue, 08 Sep 2015 14:39:01 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996375#M974057 2015-09-08T14:39:01Z Re: Filtering the Data https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996376#M974058 <HTML><HEAD></HEAD><BODY><P>What is your question?</P></BODY></HTML> Tue, 08 Sep 2015 14:52:56 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996376#M974058 m_woolf 2015-09-08T14:52:56Z Re: Filtering the Data https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996377#M974059 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Trying to filter the data(i.e., <SPAN style="font-size: 8pt;">sum(</SPAN><SPAN style="color: #800000; font-size: 8pt;">DENOMINATOR</SPAN><SPAN style="font-size: 8pt;">) )</SPAN> by Lob Id</P><P>Can you please refer in the screen shot and qvw.file so that you will get an clear idea. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 08 Sep 2015 14:55:49 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996377#M974059 2015-09-08T14:55:49Z Re: Filtering the Data https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996378#M974060 <HTML><HEAD></HEAD><BODY><P>I'm not quite sure what's the question here. Based on your screen shot, LOB 709 doesn't exist in May 2016.</P><P></P><P>On the other hand, the attached QVW file only contains data for April and June, so it's hard to recreate the same picture.</P><P></P><P>You may need to explain your problem in more detail - what exactly is wrong?</P></BODY></HTML> Tue, 08 Sep 2015 14:57:46 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996378#M974060 Oleg_Troyansky 2015-09-08T14:57:46Z Re: Filtering the Data https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996379#M974061 <HTML><HEAD></HEAD><BODY><P>sorry for the confusion. please exclude LOB 709. The screen shot is just the <STRONG>sample data</STRONG>. You dont have to get the exact values, we have to filter the data by the LOB ID condition.</P></BODY></HTML> Tue, 08 Sep 2015 15:17:38 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996379#M974061 2015-09-08T15:17:38Z Re: Filtering the Data https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996380#M974062 <HTML><HEAD></HEAD><BODY><P>I still don't understand what your question is. If you need to filter by LOB ID, what's stopping you?</P></BODY></HTML> Tue, 08 Sep 2015 15:20:07 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996380#M974062 m_woolf 2015-09-08T15:20:07Z Re: Filtering the Data https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996381#M974063 <HTML><HEAD></HEAD><BODY><P>Sorry for the incorrect question. i need to create a expression for that condition. </P></BODY></HTML> Tue, 08 Sep 2015 15:29:34 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996381#M974063 2015-09-08T15:29:34Z Re: Filtering the Data https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996382#M974064 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">sum({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">LOB_ID</SPAN><SPAN style="font-size: 8pt;"> ={705,706,713}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">DENOMINATOR</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P></BODY></HTML> Tue, 08 Sep 2015 16:13:42 GMT https://community.qlik.com/t5/QlikView/Filtering-the-Data/m-p/996382#M974064 2015-09-08T16:13:42Z