Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

stacked chart dimension limits

Hello all,

I'm creating a stacked chart that should result into 100%.

this works as you can see below. (I had to pick these ugly colors)

Now there question is to only show CR and CN and group the rest in Others.

I made a sorting which puts these two first and then I used dimension limits to show only first 3.

But some months there is no CN or CR so in those cases other types are popping up. Which I don't want.

I only want to show CN and CR and always the rest on Others. could someone help me with this?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use a calculated dimension: =if(Match([Rejection Type],'CN','CR'),[Rejection Type],'Others')


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Not applicable
Author

anyone?

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use a calculated dimension: =if(Match([Rejection Type],'CN','CR'),[Rejection Type],'Others')


talk is cheap, supply exceeds demand
Not applicable
Author

That's it. Now getting the sorting in order and it is finished. Thank you.