topic Re: Conditional Expression in QlikView https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407607#M426077 <HTML><HEAD></HEAD><BODY><P>Just check 'Suppress When Value Is Null' for your first dimension on the dimensions tab of chart properties</P></BODY></HTML> Wed, 13 Sep 2017 16:25:06 GMT sunny_talwar 2017-09-13T16:25:06Z Conditional Expression https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407603#M426073 <HTML><HEAD></HEAD><BODY><P>I have following pivot table in My Doc</P><P><IMG alt="Screenshot_1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176399_Screenshot_1.png" style="height: 307px; width: 620px;" /></P><P>I want to show under the Financial Institute Column only Institutes which exceeds only 10% of total Value-2016</P><P>eg:&nbsp; Arpico Finance= Net Total/Total</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 75836/77277= 98% to be shown</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Natition Insuranec Brokers= 2200/77277= 2.8% not to be shown</P><P></P><P>My Calculated dimension for Financial Institute is </P><P><IMG alt="Screenshot_2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/176401_Screenshot_2.png" style="height: auto;" /></P><P>Can you suggest me solution for this&nbsp; and It should be for pivot table please.</P></BODY></HTML> Wed, 13 Sep 2017 11:20:30 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407603#M426073 upaliwije 2017-09-13T11:20:30Z Re: Conditional Expression https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407604#M426074 <HTML><HEAD></HEAD><BODY><P>Please share some sample app. </P></BODY></HTML> Wed, 13 Sep 2017 11:38:57 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407604#M426074 prma7799 2017-09-13T11:38:57Z Re: Conditional Expression https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407605#M426075 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176391_Capture.PNG" style="height: 178px; width: 620px;" /></P></BODY></HTML> Wed, 13 Sep 2017 11:54:51 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407605#M426075 sunny_talwar 2017-09-13T11:54:51Z Re: Conditional Expression https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407606#M426076 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny</P><P>It is really amazing your solutions. However When I apply this to my original document I get an additional row just below the total row. What could be the reason ? Further I can not understand this <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">1e10 . </STRONG>Pls&nbsp; help</P><P></P><P><IMG alt="Screenshot_2.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176449_Screenshot_2.png" style="height: 322px; width: 620px;" /></P></BODY></HTML> Wed, 13 Sep 2017 16:20:29 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407606#M426076 upaliwije 2017-09-13T16:20:29Z Re: Conditional Expression https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407607#M426077 <HTML><HEAD></HEAD><BODY><P>Just check 'Suppress When Value Is Null' for your first dimension on the dimensions tab of chart properties</P></BODY></HTML> Wed, 13 Sep 2017 16:25:06 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407607#M426077 sunny_talwar 2017-09-13T16:25:06Z Re: Conditional Expression https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407608#M426078 <HTML><HEAD></HEAD><BODY><P>Thanks a lot Sunny</P></BODY></HTML> Wed, 13 Sep 2017 16:38:55 GMT https://community.qlik.com/t5/QlikView/Conditional-Expression/m-p/1407608#M426078 upaliwije 2017-09-13T16:38:55Z