Discussion Board for collaboration related to QlikView App Development.
Hi , just having some difficulty with setting a field (ResDayNum) based on another field (KeyDateNum).
Hopefully this explains the problem....
Go to Solution.
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)).
View solution in original post
Thanks - interesting to know the row dimensions still applies in set analysis