topic If condition for the scenario in QlikView https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936015#M323124 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need help in writing if condition. Attached the Qvw.</P><P></P><P>All the details are mentioned in the QVW.</P><P></P><P>Regards,</P><P>Keerthi KS</P></BODY></HTML> Wed, 04 Nov 2015 11:59:16 GMT 2015-11-04T11:59:16Z If condition for the scenario https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936015#M323124 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need help in writing if condition. Attached the Qvw.</P><P></P><P>All the details are mentioned in the QVW.</P><P></P><P>Regards,</P><P>Keerthi KS</P></BODY></HTML> Wed, 04 Nov 2015 11:59:16 GMT https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936015#M323124 2015-11-04T11:59:16Z Re: If condition for he scenario https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936016#M323125 <HTML><HEAD></HEAD><BODY><P>Did not get you.</P><P></P><P>Both are two different reports with Draft as one and Expired as 2nd.</P><P></P><P>what exactly you want?</P></BODY></HTML> Wed, 04 Nov 2015 12:09:38 GMT https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936016#M323125 Anonymous 2015-11-04T12:09:38Z Re: If condition for the scenario https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936017#M323126 <HTML><HEAD></HEAD><BODY><P>Lets say Enq_contactname Mr Pavani is there with both Off_status Draft and Expired.</P><P>Since the Off_status is Draft it should not be shown in Expired table (2nd)</P></BODY></HTML> Wed, 04 Nov 2015 12:13:04 GMT https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936017#M323126 2015-11-04T12:13:04Z Re: If condition for the scenario https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936018#M323127 <HTML><HEAD></HEAD><BODY><P>Is this what you want?</P></BODY></HTML> Wed, 04 Nov 2015 12:18:12 GMT https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936018#M323127 Anonymous 2015-11-04T12:18:12Z Re: If condition for the scenario https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936019#M323128 <HTML><HEAD></HEAD><BODY><P>Suppress value null for all dimension as well</P></BODY></HTML> Wed, 04 Nov 2015 12:20:54 GMT https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936019#M323128 Anonymous 2015-11-04T12:20:54Z Re: If condition for the scenario https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936020#M323129 <HTML><HEAD></HEAD><BODY><P>Failed to open document</P></BODY></HTML> Wed, 04 Nov 2015 12:24:06 GMT https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936020#M323129 2015-11-04T12:24:06Z Re: If condition for the scenario https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936021#M323130 <HTML><HEAD></HEAD><BODY><P>u r using personal edition?</P></BODY></HTML> Wed, 04 Nov 2015 12:26:52 GMT https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936021#M323130 Anonymous 2015-11-04T12:26:52Z Re: If condition for the scenario https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936022#M323131 <HTML><HEAD></HEAD><BODY><P>no got licence</P></BODY></HTML> Wed, 04 Nov 2015 12:28:14 GMT https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936022#M323131 2015-11-04T12:28:14Z Re: If condition for the scenario https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936023#M323132 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Use this expression in your Expired table &amp; suppress null for each dimension</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">=if(Off_Status&lt;&gt;'Draft' and Off_Status&lt;&gt;'Expired',Enq_ContactName)</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">See the attachment</P></BODY></HTML> Wed, 04 Nov 2015 12:29:57 GMT https://community.qlik.com/t5/QlikView/If-condition-for-the-scenario/m-p/936023#M323132 Anonymous 2015-11-04T12:29:57Z