topic Re: Colors in pie chart in QlikView

Colors in pie chart

arpitkharkia — Sat, 16 Nov 2024 03:39:01 GMT

Hi All,

I have a pie chart with a calculated dimension.The dimension is getting sorted in the 'Sort' tab as i have used dual() while creating the calculated dimension. Please consider img1 and img2. The colors show up as i want it in img1 when persistent color is not on. But when its on, as can be seen in img2, the color order changes.

Im not sure why its happening, because when i tried to create a sample app for posting it was working fine there.

Any help will be appreciated!

Thanks!

Arpit

Re: Colors in pie chart

rubenmarin — Tue, 07 May 2019 16:43:13 GMT

Hi, if you want it as in image1... why not just uncheck persistent colors?
I think that persistent colors are assigned in the same order values are created, which can be different than the alphabetic or numeric order.

Re: Colors in pie chart

arpitkharkia — Tue, 07 May 2019 16:46:15 GMT

Thats correct. thats what i had before, but the requirement is that once a bucket is clicked, the color should be same as the bucket. In img1, if i click the pink bucket, the color changes to green, it should remain as pink. Thats why i checked on persistent color.

Re: Colors in pie chart

rubenmarin — Wed, 08 May 2019 11:04:56 GMT

Maybe setting color as background color of the expression, and unsing something like:
Color(Match([ConditionalDimensioneExpression], '0 - 5 Days', '6 - 1000 Days', '1001+ Days'))

Re: Colors in pie chart

arpitkharkia — Sat, 11 May 2019 08:53:54 GMT

The following helped me in resolving the issue:

https://community.qlik.com/t5/New-to-QlikView/Issue-with-calculated-dimension-and-chart-color/td-p/32496