Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
GhostWarrior44
Contributor
Contributor

Help With Heat Map to Carpet Chart

Hi All,

I've effectively been using a heat map as my carpet chart, Currently I have : Count({$<[Item Rev Status5]={'Approved' , 'NA'}>}[Item Rev Status5]) : GREEN

And , Count({$<[Item Rev Status5]={'Not Submitted', 'Rejected', 'In Review'}>}[Item Rev Status5]) : RED

 

Id like to be able to Count and make more than two colors......I have 5 Statuses.... "Approved, In Review, Rejected, Not Submitted and NA" .... Id like to get a diff color for each one....does anyone have any suggestions....

PS: They can only be in one status at a time.... Gradient scale wouldn't wont work....

Thanks!!!

 

2 Replies
Lisa_P
Employee
Employee

You could create an additional field with values 1-5 for each status and use that field (no aggregation) as the measure and apply the Diverging BuYlRd 5 values color schema
GhostWarrior44
Contributor
Contributor
Author

Great suggestion. It works great. Thank you