100% Bar Chart Issue

kmmqlick — Sat, 16 Nov 2024 17:59:17 GMT

Hi All,

I am facing a problem with 100% Stacked bar chart .I have category filter, when i select particular category i want to change years(example Cateogory-A only years need to show is 2019-2022 and Category-B only 2020-2023).Please help me to solve this problem.

Re: 100% Bar Chart Issue

Kushal_Chawda — Mon, 12 Oct 2020 09:38:47 GMT

@kmmqlick try below

=if(getfieldseletions([Category]='Category-A',

sum({<Year ={">=$(=min(Year))<=$(=max(Year)-1)"}>}Sales)/sum(total <Year>{<Year ={">=$(=min(Year))<=$(=max(Year)-1)"}>}Sales),

if(getfieldseletions([Category]='Category-B',

sum({<Year ={">=$(=min(Year)-1)<=$(=max(Year))"}>}Sales)/sum(total <Year>{<Year ={">=$(=min(Year)-1)<=$(=max(Year))"}>}Sales),

sum(Sales)/sum(total <Year>Sales)))

topic Re: 100% Bar Chart Issue in QlikView

100% Bar Chart Issue

Re: 100% Bar Chart Issue