topic Re: 100% Stacked Bar with Nulls in QlikView https://community.qlik.com/t5/QlikView/100-Stacked-Bar-with-Nulls/m-p/1222765#M390755 <HTML><HEAD></HEAD><BODY><P>Could you please post some sample data here..</P><P></P><P>if I am not wrong</P><P></P><P>u can try like this&nbsp;&nbsp; if(not isnull(&lt;[Agent Name]) ,</P><P></P><P>Count(RecordID) / Count(TOTAL &lt;[Agent Name]&gt; RecordID))</P></BODY></HTML> Fri, 03 Mar 2017 05:14:40 GMT 2017-03-03T05:14:40Z 100% Stacked Bar with Nulls https://community.qlik.com/t5/QlikView/100-Stacked-Bar-with-Nulls/m-p/1222764#M390754 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I'm trying to create a 100% stacked bar chart, but eliminate the NULL values from the data set.&nbsp; I know I can deselect "Show Null Values" from the chart settings, but clicking on the graph still pulls in the nulls into the data set.&nbsp; </P><P></P><P>I'm using the following Expression:&nbsp; </P><P></P><P>Count(RecordID) / Count(TOTAL &lt;[Agent Name]&gt; RecordID)</P><P></P><P><IMG alt="Screen Shot 2017-03-02 at 8.29.46 PM.png" class="jive-image image-1" src="/legacyfs/online/155086_Screen Shot 2017-03-02 at 8.29.46 PM.png" style="height: 380px; width: 620px;" /></P></BODY></HTML> Fri, 03 Mar 2017 02:34:00 GMT https://community.qlik.com/t5/QlikView/100-Stacked-Bar-with-Nulls/m-p/1222764#M390754 joshakehurst 2017-03-03T02:34:00Z Re: 100% Stacked Bar with Nulls https://community.qlik.com/t5/QlikView/100-Stacked-Bar-with-Nulls/m-p/1222765#M390755 <HTML><HEAD></HEAD><BODY><P>Could you please post some sample data here..</P><P></P><P>if I am not wrong</P><P></P><P>u can try like this&nbsp;&nbsp; if(not isnull(&lt;[Agent Name]) ,</P><P></P><P>Count(RecordID) / Count(TOTAL &lt;[Agent Name]&gt; RecordID))</P></BODY></HTML> Fri, 03 Mar 2017 05:14:40 GMT https://community.qlik.com/t5/QlikView/100-Stacked-Bar-with-Nulls/m-p/1222765#M390755 2017-03-03T05:14:40Z