Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
GhostWarrior44
New 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
Employee
Employee

Re: Help With Heat Map to Carpet Chart

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
New Contributor

Re: Help With Heat Map to Carpet Chart

Great suggestion. It works great. Thank you