two different year sales in a single bar

[Anonymous]

hello everyone

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 & 2017. please help me to find out solution.

Thank you.

[Anil_Babu_Samineni]

Don't unique for single issue Different year value in a single bar with different color

[Anonymous]

still i am not getting proper solution. what should i do............

[Anil_Babu_Samineni]

If you are not getting any response over here. that would you like to add one more thread with same issue ??

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.

[woshua5550]

this doesn't fulfill you requirement ?

[Anonymous]

ya but it shows sale sales for both year and one thing i have data from 2000 to 2017

[Anonymous]

same sales

[woshua5550]

OK I see , that because your "year" field is in lower case and your expression is "Sum({<Year = {2017}>}Sales)" which will calculate wrongly.

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

[Anonymous]

that was my dummy data, it was created only for posting on community

[Anonymous]

it is possible to  give one more condition like category wise sales