topic How to create columns based on values in QlikView https://community.qlik.com/t5/QlikView/How-to-create-columns-based-on-values/m-p/73507#M458171 <HTML><HEAD></HEAD><BODY><P>Hi, Below is my requirement :</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201905_Capture.PNG" style="height: 61px; width: 620px;" /></P><P>I want three columns based on values.</P><P>1. If Actual &gt; Target, It should appear in the first column Green.</P><P>2. If (Target - Actual) &gt; 5, It should come under 2nd one Amber.</P><P>3. If Actual &lt;&nbsp; Target, It should come in 3rd one Red.</P><P></P><P>How can I get this?</P><P></P><P>Thank You!</P></BODY></HTML> Wed, 09 May 2018 01:50:32 GMT amruta_j 2018-05-09T01:50:32Z How to create columns based on values https://community.qlik.com/t5/QlikView/How-to-create-columns-based-on-values/m-p/73507#M458171 <HTML><HEAD></HEAD><BODY><P>Hi, Below is my requirement :</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201905_Capture.PNG" style="height: 61px; width: 620px;" /></P><P>I want three columns based on values.</P><P>1. If Actual &gt; Target, It should appear in the first column Green.</P><P>2. If (Target - Actual) &gt; 5, It should come under 2nd one Amber.</P><P>3. If Actual &lt;&nbsp; Target, It should come in 3rd one Red.</P><P></P><P>How can I get this?</P><P></P><P>Thank You!</P></BODY></HTML> Wed, 09 May 2018 01:50:32 GMT https://community.qlik.com/t5/QlikView/How-to-create-columns-based-on-values/m-p/73507#M458171 amruta_j 2018-05-09T01:50:32Z Re: How to create columns based on values https://community.qlik.com/t5/QlikView/How-to-create-columns-based-on-values/m-p/73508#M458172 <HTML><HEAD></HEAD><BODY><P>Are you comparing row level values or are you comparing Aggregated values (Sum(Actual) and Sum(Target))? Also, do you need this in the script or front end?</P></BODY></HTML> Wed, 09 May 2018 11:44:33 GMT https://community.qlik.com/t5/QlikView/How-to-create-columns-based-on-values/m-p/73508#M458172 sunny_talwar 2018-05-09T11:44:33Z