Solved: Set Analysis - how to set a field based on another - Qlik Community

Report Inappropriate Content · ‎2013-10-09

Hi , just having some difficulty with setting a field (ResDayNum) based on another field (KeyDateNum).

Hopefully this explains the problem....

Gysbert_Wassenaar · ‎2013-10-10

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)).

talk is cheap, supply exceeds demand

View solution in original post

Gysbert_Wassenaar · ‎2013-10-10

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)).

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2013-10-10

Thanks - interesting to know the row dimensions still applies in set analysis