Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense set analysis

what i am attempting to do is as follows:

two KPI objects, one for 2009 payroll, another for 2010 payroll. in the second object i want to show numbers colored based on if payroll has increased, decreased or stayed the same with colors as red(increased), green(decreased), yellow(no change). Can't get the colors to show correctly!

i am using the expression as a max number so it is dynamic.  =Sum({$<Year={2009}>}Pay)

Can anyone please help?

0 Replies