

Creator III
2019-05-07
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Colors in pie chart
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
1,709 Views
1 Solution
Accepted Solutions


Creator III
2019-05-11
04:53 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/3...
https://community.qlik.com/t5/New-to-QlikView/Issue-with-calculated-dimension-and-chart-color/td-p/3...
1,656 Views
4 Replies

MVP
2019-05-07
12:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
I think that persistent colors are assigned in the same order values are created, which can be different than the alphabetic or numeric order.
1,702 Views


Creator III
2019-05-07
12:46 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
1,696 Views

MVP
2019-05-08
07:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe setting color as background color of the expression, and unsing something like:
Color(Match([ConditionalDimensioneExpression], '0 - 5 Days', '6 - 1000 Days', '1001+ Days'))
Color(Match([ConditionalDimensioneExpression], '0 - 5 Days', '6 - 1000 Days', '1001+ Days'))
1,671 Views


Creator III
2019-05-11
04:53 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/3...
https://community.qlik.com/t5/New-to-QlikView/Issue-with-calculated-dimension-and-chart-color/td-p/3...
1,657 Views
