topic Re: Stacked Bar Chart: Total Items in Year Range in QlikView

Stacked Bar Chart: Total Items in Year Range

Lisa2 — Sat, 16 Nov 2024 01:18:26 GMT

Hello, I am creating a stacked bar chart where it is one stacked bar that includes all items, in a range of years and total cost. I get an error in the calculation. How do I fix this?

Below is example data

Year	Item	Cost
2020	Box	425
2020	Pencil	214
2020	Chair	453
2020	Pen	283
2021	Box	315
2021	Pencil	587
2021	Chair	752
2021	Pen	145
2022	Box	785
2022	Pencil	214
2022	Chair	567
2022	Pen	54
2023	Box	298
2023	Pencil	236
2023	Chair	5447
2023	Pen	987
2024	Box	14
2024	Pencil	52
2024	Chair	254
2024	Pen	789
2025	Box	45
2025	Pencil	145
2025	Chair	8
2025	Pen	369
2026	Box	25
2026	Pencil	4
2026	Chair	1258
2026	Pen	78
2027	Box	126
2027	Pencil	58
2027	Chair	24
2027	Pen	2523

Here is what I have under Used Dimensions --> Add Calculated Dimension:

=sum({<Year={'>=2020<=2024'}>}Cost)

Here is what I get:

Re: Stacked Bar Chart: Total Items in Year Range

Arthur_Fong — Wed, 12 Feb 2020 05:03:40 GMT

Try this:

=aggr(sum({<Year={">=2020<=2024"}>}Cost),Item)

Re: Stacked Bar Chart: Total Items in Year Range

alex00321 — Wed, 12 Feb 2020 08:11:00 GMT

Hi I use double quote, and it worked: =sum({<Year={">=2020<=2024"}>}Cost)

Re: Stacked Bar Chart: Total Items in Year Range

Lisa2 — Wed, 12 Feb 2020 21:28:31 GMT

Nothing is working for me.

Re: Stacked Bar Chart: Total Items in Year Range

Brett_Bleess — Tue, 10 Mar 2020 20:27:06 GMT

The best avenue for you to receive further help would be to attach the QVW file or a sample that shows the issue, so folks can look everything over completely including the data model.

Regards,
Brett

Re: Stacked Bar Chart: Total Items in Year Range

qliksus — Wed, 11 Mar 2020 11:26:28 GMT

You need multiple results to stack . why dont you add Year and Item in the dimension and use the expression

sum({<Year={'>=2020<=2024'}>}Cost)