topic Re: How to show 2 expressions in 2 lines using subtype stacked ? in QlikView https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193290#M385249 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG __jive_id="139111" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139111_Capture.PNG" style="height: 362px; width: 620px;" /></P></BODY></HTML> Thu, 29 Sep 2016 12:08:55 GMT adamdavi3s 2016-09-29T12:08:55Z How to show 4 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193288#M385247 <HTML><HEAD></HEAD><BODY><P>hello everybody ,</P><P>we ha a bar chart with 2 expressions : brutto , netto and dim year ,&nbsp; subtype=stacked ,&nbsp; look like :</P><P><IMG __jive_id="139139" alt="bar 1 stnd.PNG" class="jive-image image-1" height="232" src="/legacyfs/online/139139_bar 1 stnd.PNG" style="height: 232px; width: 395.89px;" width="396" /></P><P>we need to show&nbsp; <SPAN style="font-size: 13.3333px;">brutto , netto&nbsp; in 2 different calculations that give us<STRONG> 4 expressions</STRONG> ,&nbsp; so there is a line for each&nbsp; , something like this :</SPAN></P><P><SPAN style="font-size: 13.3333px;"><IMG __jive_id="139140" alt="bar 2 stnd.PNG" class="jive-image image-2" height="252" src="/legacyfs/online/139140_bar 2 stnd.PNG" style="height: 251.76px; width: 380px;" width="380" /><BR /></SPAN></P><P></P><P>i am sure there is awy to do it , can you help ?&nbsp; thanks!!</P></BODY></HTML> Thu, 29 Sep 2016 11:53:04 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193288#M385247 yanivvl0 2016-09-29T11:53:04Z Re: How to show 2 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193289#M385248 <HTML><HEAD></HEAD><BODY><P>You can try combo chart with one expression is bar and one more is line. Or else if you are referring different then use style is static instead of group</P></BODY></HTML> Thu, 29 Sep 2016 11:57:53 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193289#M385248 Anil_Babu_Samineni 2016-09-29T11:57:53Z Re: How to show 2 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193290#M385249 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG __jive_id="139111" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139111_Capture.PNG" style="height: 362px; width: 620px;" /></P></BODY></HTML> Thu, 29 Sep 2016 12:08:55 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193290#M385249 adamdavi3s 2016-09-29T12:08:55Z Re: How to show 2 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193291#M385250 <HTML><HEAD></HEAD><BODY><P>hi Adam , not exactly , because i have only one dimension , and to be more cleare 4 ( not 2 ) expressions , <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> brutto , netto calc type 1 and <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> brutto , netto calc type 2.&nbsp;&nbsp;&nbsp; sorry for not writing this before.</SPAN></SPAN></P></BODY></HTML> Thu, 29 Sep 2016 12:20:33 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193291#M385250 yanivvl0 2016-09-29T12:20:33Z Re: How to show 2 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193292#M385251 <HTML><HEAD></HEAD><BODY><P>hmmmm can you share some simple data in excel or a qvw? sorry my brain isn't up to speed today!</P></BODY></HTML> Thu, 29 Sep 2016 12:25:24 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193292#M385251 adamdavi3s 2016-09-29T12:25:24Z Re: How to show 2 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193293#M385252 <HTML><HEAD></HEAD><BODY><P>Did you manage to solve this one?</P></BODY></HTML> Fri, 30 Sep 2016 14:29:14 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193293#M385252 adamdavi3s 2016-09-30T14:29:14Z Re: How to show 2 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193294#M385253 <HTML><HEAD></HEAD><BODY><P>hi , here an example of 1 dim and 4 expr ,</P><P>i need brutto_1 &amp; netto_1 stacked in one line , and <SPAN style="font-size: 13.3333px;"> brutto_2 &amp; netto_2 stacked in anothet line ,</SPAN></P><P><SPAN style="font-size: 13.3333px;">thanks !</SPAN></P></BODY></HTML> Wed, 05 Oct 2016 06:20:22 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193294#M385253 yanivvl0 2016-10-05T06:20:22Z Re: How to show 2 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193295#M385254 <HTML><HEAD></HEAD><BODY><P>Awesome, it is much easier to work with data that makes sense <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Does this work for you?</P></BODY></HTML> Wed, 05 Oct 2016 06:43:14 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193295#M385254 adamdavi3s 2016-10-05T06:43:14Z Re: How to show 2 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193296#M385255 <HTML><HEAD></HEAD><BODY><P>great help Adam - thanks !!</P></BODY></HTML> Wed, 05 Oct 2016 09:06:29 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193296#M385255 yanivvl0 2016-10-05T09:06:29Z Re: How to show 2 expressions in 2 lines using subtype stacked ? https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193297#M385256 <HTML><HEAD></HEAD><BODY><P>No worries at all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>If your real world data is more complicated then use Pick(match()) instead of IF as it will work faster, but in this case it will work.</P></BODY></HTML> Wed, 05 Oct 2016 09:08:05 GMT https://community.qlik.com/t5/QlikView/How-to-show-4-expressions-in-2-lines-using-subtype-stacked/m-p/1193297#M385256 adamdavi3s 2016-10-05T09:08:05Z