Solved: Re: Stacked Bar Chart Issue - Qlik Community

Report Inappropriate Content · ‎2016-06-15

Attached is the sketch of the required bar chart. Along with the sample Excel file.

Looking for help in building this chart

Report Inappropriate Content · ‎2016-06-16

no what I meant is lets say If I have another field called State and I want to use the same metrics for the filed of 'GA' for example

Something like

=Sum({<State={'GA'}>} Amount)

/

Sum({< State ={'GA'}> } TOTAL <Year> Amount)

its not working??

sunny_talwar · ‎2016-06-15

I guess create a new field from Sales Date. -> Year([Sales Date]) as [Sales Year]

And then use Year as your 1st dimension and Sales Year as second dimension

Expression:

Sum(Amount)/Sum(TOTAL <Year> Amount)

Report Inappropriate Content · ‎2016-06-15

But if you look at the sketch I need to group the previous 2 years as one block and anything older then 3 yrs as a seperate block

sunny_talwar · ‎2016-06-15

May be create a flag in the script:

If(Year = Year([Sales Date]) or Year = Year([Sales Date]) + 1, Year([Sales Date]), Dual('<=' & (Year -2), (Year - 2))) as [Sales Year]

And then then same two dimensions and try the same expression

Report Inappropriate Content · ‎2016-06-15

Can you please post a sample qvw

sunny_talwar · ‎2016-06-15

Like this:

Report Inappropriate Content · ‎2016-06-16

Yes exactly. can you pls post the QVW?

sunny_talwar · ‎2016-06-16

I did add it to my response above. Open the link here ->Re: Stacked Bar Chart Issue

Report Inappropriate Content · ‎2016-06-16

Got it, one last question. I am still not able to do the 3 stacks, so if Year is 2016 I would like to see

Stack 1 Sale Year = Year

Stack 2 Sale Year = Year-1 and Year -2

Stack 3 Sale Year <= Year -3

All 3 stacks should add up to 100%

sunny_talwar · ‎2016-06-16

Above image is showing three stacks and they are adding up to 100%. Did you follow the similar logic in the script?