Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
nagarjuna9563
Contributor
Contributor

How to create categorization field based on other fields

Hi All,

i have a requirement for developing the below attached screen shot.

nagarjuna9563_0-1632299414352.png

2 dimensions, 3 metrics we have implemented in this screen shot.

But here issue is Green, Yellow and Red colors represent the categorization.

Categorization Logic:

Actual >= target  and [forecast actual] >= [forecast target] then Green 

Actual >= target  and [forecast actual] <  [forecast target] or

Actual < target  and [forecast actual] >= [forecast target] then Yellow

Actual < target  and [forecast actual] < [forecast target] then Red

 

How we will do categorization, is this possible to implement at chart level or at scripting level?

if scripting level, how to do? and if chart level how to do?

Can you let me know correct one please?

 

Thanks & Regards,

Nagarjuna.

0 Replies