Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Lisa2
New 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
Highlighted
Partner
Partner

Re: Combine Years to one Bar

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
Highlighted
Partner
Partner

Re: Combine Years to one Bar

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

Make sure you Item is above Year in the dimensions

Highlighted
Lisa2
New Contributor

Re: Combine Years to one Bar

One 5 year range bar with Items stacked.

Highlighted
Partner
Partner

Re: Combine Years to one Bar

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

Highlighted
Lisa2
New Contributor

Re: Combine Years to one Bar

Stacked Items

 

Stacked.PNG

Highlighted
Partner
Partner

Re: Combine Years to one Bar

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