Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramanarayan
Creator
Creator

Issue with calculated dimension and chart color

Hi Experts,

I am trying to create a chart with a calculated dimension but for some reason i am not getting the desired output.

Here are the challenges i face.

1) All values in the dimension does not show up on the chart

2) The color expression does not work and i see the entire pie chart in black color

3) The legends are not correct as per the numbers

Attached is the data and my qvw file.

Appreciate your help.

Thanks

1 Solution

Accepted Solutions
sunny_talwar

Is this what you are looking to get?

Capture.PNG

View solution in original post

4 Replies
MK_QSL
MVP
MVP

Because your activity and total days are not having one to many.. but many to many relationship..

For Medium and Low activity, you have Medium (30 to 90 Days)

For Inactive Activity you have High and Low both..


So your if statement can't recognise which segment should be given which colour.

Add Activity in your dimension so that you can understand what the issue is.

sunny_talwar

Is this what you are looking to get?

Capture.PNG

View solution in original post

ramanarayan
Creator
Creator
Author

Appreciate your help Sunny. This is what i need.

Have a gr8 rest of your day

Rahul_1
Contributor
Contributor

Hi Sunny,

Can you please share your expression for the above problem statement?

I too have same doubt for coloring a calculated dimension.

Regards,

Rahul