topic Qlik Sense set analysis in QlikView https://community.qlik.com/t5/QlikView/Qlik-Sense-set-analysis/m-p/836816#M294292 <HTML><HEAD></HEAD><BODY><P>what i am attempting to do is as follows:</P><P>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!</P><P>i am using the expression as a max number so it is dynamic.&nbsp; =Sum({$&lt;Year={2009}&gt;}Pay)</P><P>Can anyone please help?</P></BODY></HTML> Wed, 01 Apr 2015 16:26:14 GMT 2015-04-01T16:26:14Z Qlik Sense set analysis https://community.qlik.com/t5/QlikView/Qlik-Sense-set-analysis/m-p/836816#M294292 <HTML><HEAD></HEAD><BODY><P>what i am attempting to do is as follows:</P><P>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!</P><P>i am using the expression as a max number so it is dynamic.&nbsp; =Sum({$&lt;Year={2009}&gt;}Pay)</P><P>Can anyone please help?</P></BODY></HTML> Wed, 01 Apr 2015 16:26:14 GMT https://community.qlik.com/t5/QlikView/Qlik-Sense-set-analysis/m-p/836816#M294292 2015-04-01T16:26:14Z