topic Re: Combo Chart - formula needed to filter out info in App Development https://community.qlik.com/t5/App-Development/Combo-Chart-formula-needed-to-filter-out-info/m-p/1338420#M29448 <HTML><HEAD></HEAD><BODY><P>You can find some information here: <A href="https://community.qlik.com/qlik-blogpost/4076">A Primer on Set Analysis</A></P></BODY></HTML> Sun, 21 May 2017 07:36:17 GMT Gysbert_Wassenaar 2017-05-21T07:36:17Z Combo Chart - formula needed to filter out info https://community.qlik.com/t5/App-Development/Combo-Chart-formula-needed-to-filter-out-info/m-p/1338417#M29445 <HTML><HEAD></HEAD><BODY><P>hello forum,</P><P></P><P>I would need your help with below challenge.</P><P></P><P>i would need to create a combo chart to show simultaneous 2 categories using Bar chart type.</P><P></P><P>I know i need to pt some formula to restrict the count for the values for "catA" and respectivelly "catB" but i don't know how.</P><P>any help/direction is more than welcome</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163202_Untitled.png" style="height: 357px; width: 620px;" /></P></BODY></HTML> Fri, 12 May 2017 15:30:52 GMT https://community.qlik.com/t5/App-Development/Combo-Chart-formula-needed-to-filter-out-info/m-p/1338417#M29445 2017-05-12T15:30:52Z Re: Combo Chart - formula needed to filter out info https://community.qlik.com/t5/App-Development/Combo-Chart-formula-needed-to-filter-out-info/m-p/1338418#M29446 <HTML><HEAD></HEAD><BODY><P>Using [Dunning Level] as dimension as you do now and add two expressions for the two categories:</P><UL><LI>count({&lt;MyCategory={'catA'}&gt;} MyItem)</LI><LI><SPAN style="font-size: 13.3333px;">count({&lt;MyCategory={'catB'}&gt;} MyItem)</SPAN></LI></UL><P>Replace MyCategory and MyItem with the appropriate field names from your data model.</P></BODY></HTML> Fri, 12 May 2017 17:48:26 GMT https://community.qlik.com/t5/App-Development/Combo-Chart-formula-needed-to-filter-out-info/m-p/1338418#M29446 Gysbert_Wassenaar 2017-05-12T17:48:26Z Re: Combo Chart - formula needed to filter out info https://community.qlik.com/t5/App-Development/Combo-Chart-formula-needed-to-filter-out-info/m-p/1338419#M29447 <HTML><HEAD></HEAD><BODY><P>worked like a charm.</P><P></P><P>thanks a million. can u please suggest some reference materials where I can learn how to build these formulas?</P></BODY></HTML> Mon, 15 May 2017 07:00:03 GMT https://community.qlik.com/t5/App-Development/Combo-Chart-formula-needed-to-filter-out-info/m-p/1338419#M29447 2017-05-15T07:00:03Z Re: Combo Chart - formula needed to filter out info https://community.qlik.com/t5/App-Development/Combo-Chart-formula-needed-to-filter-out-info/m-p/1338420#M29448 <HTML><HEAD></HEAD><BODY><P>You can find some information here: <A href="https://community.qlik.com/qlik-blogpost/4076">A Primer on Set Analysis</A></P></BODY></HTML> Sun, 21 May 2017 07:36:17 GMT https://community.qlik.com/t5/App-Development/Combo-Chart-formula-needed-to-filter-out-info/m-p/1338420#M29448 Gysbert_Wassenaar 2017-05-21T07:36:17Z