topic Re: two different year sales in a single bar in QlikView https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443930#M801385 <HTML><HEAD></HEAD><BODY><P>still i am not getting proper solution. what should i do............</P></BODY></HTML> Thu, 23 Nov 2017 05:30:34 GMT Anonymous 2017-11-23T05:30:34Z two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443928#M801381 <HTML><HEAD></HEAD><BODY><P>hello everyone</P><P></P><P>i need to show two different year sales data in a single bar in a bar chart like below. it shows sales value of April month of year 2016 &amp; 2017. please help me to find out solution.</P><P></P><P>Thank you.<IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/184287_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443928#M801381 Anonymous 2020-11-25T16:16:04Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443929#M801383 <HTML><HEAD></HEAD><BODY><P>Don't unique for single issue <A href="https://community.qlik.com/message/1386810">Different year value in a single bar with different color</A></P></BODY></HTML> Thu, 23 Nov 2017 05:10:39 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443929#M801383 Anil_Babu_Samineni 2017-11-23T05:10:39Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443930#M801385 <HTML><HEAD></HEAD><BODY><P>still i am not getting proper solution. what should i do............</P></BODY></HTML> Thu, 23 Nov 2017 05:30:34 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443930#M801385 Anonymous 2017-11-23T05:30:34Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443931#M801387 <HTML><HEAD></HEAD><BODY><P>If you are not getting any response over here. that would you like to add one more thread with same issue <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> ??</P><P></P><P>Anyway, We are showing our best. How come we know which live data you worked for. And what i proved in bar chart is the right approach. But, the data points are not clean and neat as we have limits in Qlikview. That's where i recommend someone who good ex-plainer. You have to wait till recommends response. </P></BODY></HTML> Thu, 23 Nov 2017 05:34:42 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443931#M801387 Anil_Babu_Samineni 2017-11-23T05:34:42Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443932#M801389 <HTML><HEAD></HEAD><BODY><P>this doesn't fulfill you requirement ?</P><P><IMG alt="微信截图_20171123152908.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/184299_微信截图_20171123152908.png" style="width: 620px; height: 341px;" /></P></BODY></HTML> Thu, 23 Nov 2017 07:31:40 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443932#M801389 woshua5550 2017-11-23T07:31:40Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443933#M801391 <HTML><HEAD></HEAD><BODY><P>ya but it shows sale sales for both year and one thing i have data from 2000 to 2017</P></BODY></HTML> Thu, 23 Nov 2017 07:35:57 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443933#M801391 Anonymous 2017-11-23T07:35:57Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443934#M801394 <HTML><HEAD></HEAD><BODY><P>same sales</P></BODY></HTML> Thu, 23 Nov 2017 07:36:36 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443934#M801394 Anonymous 2017-11-23T07:36:36Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443935#M801396 <HTML><HEAD></HEAD><BODY><P>OK I see , that because your "year" field is in lower case and your expression is "Sum({&lt;Year = {2017}&gt;}Sales)" which will calculate wrongly.</P><P>how about this , I notice that we have data from 2011 to 2014 , not 2000 to 2017 , in addition ,your have a "years" field from 2011 to 2015 ,plz check</P><P><IMG alt="微信截图_20171123154055.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/184300_微信截图_20171123154055.png" style="width: 620px; height: 297px;" /></P></BODY></HTML> Thu, 23 Nov 2017 07:46:23 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443935#M801396 woshua5550 2017-11-23T07:46:23Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443936#M801398 <HTML><HEAD></HEAD><BODY><P>that was my dummy data, it was created only for posting on community</P></BODY></HTML> Thu, 23 Nov 2017 07:53:29 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443936#M801398 Anonymous 2017-11-23T07:53:29Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443937#M801399 <HTML><HEAD></HEAD><BODY><P>it is possible to&nbsp; give one more condition like category wise sales</P></BODY></HTML> Thu, 23 Nov 2017 08:10:07 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443937#M801399 Anonymous 2017-11-23T08:10:07Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443938#M801402 <HTML><HEAD></HEAD><BODY><P>that's fine , can you solve it now ? if not , what against you ?</P></BODY></HTML> Thu, 23 Nov 2017 08:13:19 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443938#M801402 woshua5550 2017-11-23T08:13:19Z Re: two different year sales in a single bar https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443939#M801404 <HTML><HEAD></HEAD><BODY><P>it is possible to&nbsp; give one more condition like category wise sales</P></BODY></HTML> Thu, 23 Nov 2017 08:19:00 GMT https://community.qlik.com/t5/QlikView/two-different-year-sales-in-a-single-bar/m-p/1443939#M801404 Anonymous 2017-11-23T08:19:00Z