topic Re: Barchart Total in QlikView https://community.qlik.com/t5/QlikView/Barchart-Total/m-p/1011097#M343075 <HTML><HEAD></HEAD><BODY><P>This may be?</P><P></P><P><STRONG>=if (column(1)&gt;0,sum({&lt;Plan = {"=Len(Trim(Plan)) &gt; 0"}&gt;}Act),null())</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/103736_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 02 Nov 2015 18:50:15 GMT sunny_talwar 2015-11-02T18:50:15Z Barchart Total https://community.qlik.com/t5/QlikView/Barchart-Total/m-p/1011096#M343074 <HTML><HEAD></HEAD><BODY><P>I face the following Problem: I have products with plan and actual. not all products have plandata.</P><P>In&nbsp; straight table I define for actual (if plandata&gt;0, sum(actual)) and I define "sum of rows" and it's good (no totals)</P><P>In a barchart I need the totals but only for those products which had been defined a plandata.</P><P>But when I define totals, there is a total for all&nbsp; products. Even if I Change my Dimension If (product &lt;&gt;'C',Product,null()) it doesnot work</P><P></P><P>How can I achieve that I see the total Actual only for those products which had been planned In the attached sample, the total should Show 150 for Actual but not 350!</P><P></P><P>any idea?</P></BODY></HTML> Mon, 02 Nov 2015 18:46:38 GMT https://community.qlik.com/t5/QlikView/Barchart-Total/m-p/1011096#M343074 Anonymous 2015-11-02T18:46:38Z Re: Barchart Total https://community.qlik.com/t5/QlikView/Barchart-Total/m-p/1011097#M343075 <HTML><HEAD></HEAD><BODY><P>This may be?</P><P></P><P><STRONG>=if (column(1)&gt;0,sum({&lt;Plan = {"=Len(Trim(Plan)) &gt; 0"}&gt;}Act),null())</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/103736_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 02 Nov 2015 18:50:15 GMT https://community.qlik.com/t5/QlikView/Barchart-Total/m-p/1011097#M343075 sunny_talwar 2015-11-02T18:50:15Z Re: Barchart Total https://community.qlik.com/t5/QlikView/Barchart-Total/m-p/1011098#M343076 <HTML><HEAD></HEAD><BODY><P>Like this?</P></BODY></HTML> Mon, 02 Nov 2015 18:52:56 GMT https://community.qlik.com/t5/QlikView/Barchart-Total/m-p/1011098#M343076 MK_QSL 2015-11-02T18:52:56Z