topic Re: Set Analysis - how to set a field based on another in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-how-to-set-a-field-based-on-another/m-p/536888#M200637 <HTML><HEAD></HEAD><BODY><P>Set analysis calculates a set per chart, not per row. So for what you want you can't use set analysis. You'll have to use an if statement. sum(if(ResDayNum=KeyDateNum,PriceN)). </P></BODY></HTML> Thu, 10 Oct 2013 06:15:23 GMT Gysbert_Wassenaar 2013-10-10T06:15:23Z Set Analysis - how to set a field based on another https://community.qlik.com/t5/QlikView/Set-Analysis-how-to-set-a-field-based-on-another/m-p/536887#M200636 <HTML><HEAD></HEAD><BODY><P>Hi , just having some difficulty with setting a field (ResDayNum) based on another field (KeyDateNum).</P><P>Hopefully this explains the problem....</P><P><IMG alt="Capture2.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/47398_Capture2.JPG.jpg" style="width: 620px; height: 297px;" /></P></BODY></HTML> Thu, 10 Oct 2013 02:40:59 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-how-to-set-a-field-based-on-another/m-p/536887#M200636 2013-10-10T02:40:59Z Re: Set Analysis - how to set a field based on another https://community.qlik.com/t5/QlikView/Set-Analysis-how-to-set-a-field-based-on-another/m-p/536888#M200637 <HTML><HEAD></HEAD><BODY><P>Set analysis calculates a set per chart, not per row. So for what you want you can't use set analysis. You'll have to use an if statement. sum(if(ResDayNum=KeyDateNum,PriceN)). </P></BODY></HTML> Thu, 10 Oct 2013 06:15:23 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-how-to-set-a-field-based-on-another/m-p/536888#M200637 Gysbert_Wassenaar 2013-10-10T06:15:23Z Re: Set Analysis - how to set a field based on another https://community.qlik.com/t5/QlikView/Set-Analysis-how-to-set-a-field-based-on-another/m-p/536889#M200638 <HTML><HEAD></HEAD><BODY><P>Thanks - interesting to know the row dimensions still applies in set analysis</P></BODY></HTML> Fri, 11 Oct 2013 03:28:20 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-how-to-set-a-field-based-on-another/m-p/536889#M200638 2013-10-11T03:28:20Z