Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa2
Contributor
Contributor

Combine Years to one Bar

Hello, I am creating a stacked bar chart, total cost of items by years where years is across the bottom.  I am only needing 5 years but I need that to show as only one bar, so combining everything in that 5 years and only showing one bar in the bar chart.  Right now I have, under the dimensions tab, YEAR and ITEM, and under the Expressions tab, I have the sum of the total cost of items.  I was thinking to make YEAR a calculated dimension but it is just not working for me.  It still separates all the years out. What do I need to do instead?

Thanks! 

Labels (1)
1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

Ok. so thats how you want to see it.

use a calculated dimension something like below

 

Min(total Year) & '-' & Max(total Year)

View solution in original post

5 Replies
dilipranjith
Partner
Partner

Do you want each bar will be an Item and stacks will be years?

Make sure you Item is above Year in the dimensions

Lisa2
Contributor
Contributor
Author

One 5 year range bar with Items stacked.

dilipranjith
Partner
Partner

please elaborate what you are seeing woith a picture and how you want it

Lisa2
Contributor
Contributor
Author

Stacked Items

 

Stacked.PNG

dilipranjith
Partner
Partner

Ok. so thats how you want to see it.

use a calculated dimension something like below

 

Min(total Year) & '-' & Max(total Year)

View solution in original post