topic Calculated Expression not displaying in Bar Graph in QlikView https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29248#M783638 <HTML><HEAD></HEAD><BODY><P>I want to create a bar graph that counts the total of sales types for each reporting period.&nbsp; However I want to combine all the 'Include' records in one graph (stacked... but not separated by each 'sales type')</P><P></P><P>Report Period&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SalesType</P><P>1&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; Include</P><P>1&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; Exlcude</P><P>1&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; Include - Sale</P><P>1&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; Include - Tax</P><P>1&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; Include - credit</P><P>1&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; Include - Coupon</P><P>1&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; Exclude - Reject</P><P>1&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; Exlcude - Feature</P><P>1&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; Include - Salary</P><P>1&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; Include - Salary</P><P>1&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; Include - Salary</P><P>1&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; Include - Salary</P><P>1&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; Include - Salary</P><P></P><P>Desired End Result: </P><P>Include: 10</P><P>Exclude: 1</P><P>Exclude - Reject: 1</P><P>Exclude - Feature: 1</P><P></P><P>I tried creating separate expressions for each count but when I do this only 1 graph is displayed.&nbsp; Please Help!</P><P><SPAN style="font-size: 8pt;">Exp1: <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;"> ({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SalesType</SPAN><SPAN style="font-size: 8pt;">={'Include','Include - Sale','Include - Tax','Include - credit','Include - Coupon'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">SalesType</SPAN><SPAN style="font-size: 8pt;">) </SPAN></SPAN></P><P><SPAN style="font-size: 8pt;">Exp2:&nbsp; <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;"> ({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SalesType</SPAN><SPAN style="font-size: 8pt;">={'Exclude'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">SalesType</SPAN><SPAN style="font-size: 8pt;">) </SPAN></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT brettaustin 2020-11-25T16:16:04Z Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29248#M783638 <HTML><HEAD></HEAD><BODY><P>I want to create a bar graph that counts the total of sales types for each reporting period.&nbsp; However I want to combine all the 'Include' records in one graph (stacked... but not separated by each 'sales type')</P><P></P><P>Report Period&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SalesType</P><P>1&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; Include</P><P>1&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; Exlcude</P><P>1&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; Include - Sale</P><P>1&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; Include - Tax</P><P>1&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; Include - credit</P><P>1&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; Include - Coupon</P><P>1&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; Exclude - Reject</P><P>1&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; Exlcude - Feature</P><P>1&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; Include - Salary</P><P>1&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; Include - Salary</P><P>1&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; Include - Salary</P><P>1&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; Include - Salary</P><P>1&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; Include - Salary</P><P></P><P>Desired End Result: </P><P>Include: 10</P><P>Exclude: 1</P><P>Exclude - Reject: 1</P><P>Exclude - Feature: 1</P><P></P><P>I tried creating separate expressions for each count but when I do this only 1 graph is displayed.&nbsp; Please Help!</P><P><SPAN style="font-size: 8pt;">Exp1: <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;"> ({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SalesType</SPAN><SPAN style="font-size: 8pt;">={'Include','Include - Sale','Include - Tax','Include - credit','Include - Coupon'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">SalesType</SPAN><SPAN style="font-size: 8pt;">) </SPAN></SPAN></P><P><SPAN style="font-size: 8pt;">Exp2:&nbsp; <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;"> ({&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">SalesType</SPAN><SPAN style="font-size: 8pt;">={'Exclude'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">SalesType</SPAN><SPAN style="font-size: 8pt;">) </SPAN></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29248#M783638 brettaustin 2020-11-25T16:16:04Z Re: Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29249#M783639 <HTML><HEAD></HEAD><BODY><P>Example of bar Graph not displaying correctly<IMG alt="Graph Example.PNG" class="jive-image image-1" src="/legacyfs/online/196376_Graph Example.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 14 Mar 2018 16:36:40 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29249#M783639 brettaustin 2018-03-14T16:36:40Z Re: Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29250#M783640 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196381_Capture.JPG" style="height: auto;" />You need calculated dimension</P><P>=if(WildMatch(SalesType,'Include*'),'Include',SalesType)</P></BODY></HTML> Wed, 14 Mar 2018 17:02:32 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29250#M783640 shiveshsingh 2018-03-14T17:02:32Z Re: Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29251#M783641 <HTML><HEAD></HEAD><BODY><P>Would you be able to share your qvw file?</P></BODY></HTML> Wed, 14 Mar 2018 17:02:38 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29251#M783641 sunny_talwar 2018-03-14T17:02:38Z Re: Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29252#M783642 <HTML><HEAD></HEAD><BODY><P>and expression will be count([Report Period])</P></BODY></HTML> Wed, 14 Mar 2018 17:04:02 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29252#M783642 shiveshsingh 2018-03-14T17:04:02Z Re: Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29253#M783643 <HTML><HEAD></HEAD><BODY><P>could you please add the qvw?</P></BODY></HTML> Wed, 14 Mar 2018 17:17:42 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29253#M783643 brettaustin 2018-03-14T17:17:42Z Re: Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29254#M783644 <HTML><HEAD></HEAD><BODY><P>Like this,</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196385_Capture.JPG" style="height: 255px; width: 620px;" /></P></BODY></HTML> Wed, 14 Mar 2018 17:17:56 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29254#M783644 Nagaraju_KCS 2018-03-14T17:17:56Z Re: Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29255#M783645 <HTML><HEAD></HEAD><BODY><P>pfa</P></BODY></HTML> Wed, 14 Mar 2018 17:19:49 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29255#M783645 shiveshsingh 2018-03-14T17:19:49Z Re: Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29256#M783646 <HTML><HEAD></HEAD><BODY><P>Thank you!!!!</P></BODY></HTML> Wed, 14 Mar 2018 17:34:06 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29256#M783646 brettaustin 2018-03-14T17:34:06Z Re: Calculated Expression not displaying in Bar Graph https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29257#M783647 <HTML><HEAD></HEAD><BODY><P>Glad to know it worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 14 Mar 2018 17:41:52 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-not-displaying-in-Bar-Graph/m-p/29257#M783647 shiveshsingh 2018-03-14T17:41:52Z