Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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

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