Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Set Analysis - how to set a field based on another

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

Hopefully this explains the problem....

Capture2.JPG.jpg

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Set Analysis - how to set a field based on another

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

2 Replies
MVP & Luminary
MVP & Luminary

Re: Set Analysis - how to set a field based on another

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

Highlighted
Not applicable

Re: Set Analysis - how to set a field based on another

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