100% Stacked Bar Chart with excluded categories

[W4ld]

Hello,

I have a stacked bar chart. The stacks are specified in a mapping-table, that translates numeric Codes into clear names like categorieexample1.

If one would now filter for certain categories, those would be filtered and I'd have 100%. I can restrict the quota via set analysis to only show how many percent the chosen categories have and just not show the rest. I now would like to make it so that in the later case there is a new category created(others), that consists of all the excluded categories.

So for example if I have 4 categories that amount to 25% each, if I filter for the first two categories only, it should show a third stack called "others" with 50%

Is there a way to do this?

[Claudiu_Anghelescu]

https://community.qlik.com/t5/QlikView-Documents/QlikView-Create-100-Full-Stacked-Bar/ta-p/1545504

maybe using also ValueList()

[W4ld]

Your link shows how to make a stacked barchart, that adds up to 100% including all the filters set for the dimension(in your example supplierIT). What I want, is that when using a filter on that dimension, everything not included in my filter gets put together in an extra categorie called others. So this would serve to only show the relevant parts of a dimension and not having the others differentiated in a ton of small slivers of data that don't really matters, but still show them in a bundled together way.

Maybe I made a mistake, but in your link I didn't find anything regarding that specific problem.

Also I don't see how Valuelist would help me, but on the other hand, I havn't yet understood what that function will ever do for me.