topic Re: stacked chart dimension limits in QlikView

stacked chart dimension limits

Fri, 06 Nov 2015 07:48:32 GMT

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?

Mon, 30 Nov 2015 07:46:28 GMT

anyone?

Gysbert_Wassenaar — Mon, 30 Nov 2015 10:20:51 GMT

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

Mon, 30 Nov 2015 10:43:39 GMT

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