topic Re: I have a set analysis that I would like to use filters to affect the restults in New to Qlik Sense
https://community.qlik.com/t5/New-to-Qlik-Sense/I-have-a-set-analysis-that-I-would-like-to-use-filters-to-affect/m-p/1603293#M141399
<P> </P><P>First of all, your formula is forcing all data to be used because of the 1 set identifier:</P><P><SPAN>=sum({<STRONG>1</STRONG><</SPAN></P><P><SPAN>Review the Set Analysis documentation to get a better understanding on set identifiers but... depending on what you need, you may want to substitute the number 1 for a $, the $ will enable any user selection to be respected in the calculation of your formula.</SPAN></P><P>Also, once you have change that, you'll need to get rid of:</P><P><EM>YEAR={'2017'}</EM></P><P>This is forcing your formula to use only 2017 data. If you get rid of this code, you'll be able to select any year anywhere in the app and make that year the applied filter for that formula.</P><P>Finally, you may want to get rid of the part:</P><P><EM>PERIOD={'Apr','Aug','Dec','Feb','Jan','Jul','Jun','May','Nov','Oct','Mar','Sep'}</EM></P><P><SPAN>That way you'll also enable users to select which PERIODS they want to see or use for that formula.</SPAN></P>Wed, 17 Jul 2019 15:40:56 GMTCarlos_Reyes2019-07-17T15:40:56ZI have a set analysis that I would like to use filters to affect the restults
https://community.qlik.com/t5/New-to-Qlik-Sense/I-have-a-set-analysis-that-I-would-like-to-use-filters-to-affect/m-p/1603289#M141397
<P>I have the following SET analysis :</P><P>=sum({1<[SCHEDULE LINE DESC]={'7041100 Cons Lns - Annual Fees Ploc','7048100 Comm Non - RE - Annual Fees','7046100 Comm RE Ln - Annual Fees Loc'},[SCHEDULE NAME]={'Income Statement'},[YEAR NAME]={'2017'},[VERSION NAME]={'Actual'},CENTER={'Institution'},PERIOD={'Apr','Aug','Dec','Feb','Jan','Jul','Jun','May','Nov','Oct','Mar','Sep'}>}Value)</P><P>I would like to be able to have the YEAR be an item I use a visualization filter to change. How do I adjust the formula?</P>Mon, 12 Apr 2021 20:51:42 GMThttps://community.qlik.com/t5/New-to-Qlik-Sense/I-have-a-set-analysis-that-I-would-like-to-use-filters-to-affect/m-p/1603289#M141397gwmills_fiserv2021-04-12T20:51:42ZRe: I have a set analysis that I would like to use filters to affect the restults
https://community.qlik.com/t5/New-to-Qlik-Sense/I-have-a-set-analysis-that-I-would-like-to-use-filters-to-affect/m-p/1603293#M141399
<P> </P><P>First of all, your formula is forcing all data to be used because of the 1 set identifier:</P><P><SPAN>=sum({<STRONG>1</STRONG><</SPAN></P><P><SPAN>Review the Set Analysis documentation to get a better understanding on set identifiers but... depending on what you need, you may want to substitute the number 1 for a $, the $ will enable any user selection to be respected in the calculation of your formula.</SPAN></P><P>Also, once you have change that, you'll need to get rid of:</P><P><EM>YEAR={'2017'}</EM></P><P>This is forcing your formula to use only 2017 data. If you get rid of this code, you'll be able to select any year anywhere in the app and make that year the applied filter for that formula.</P><P>Finally, you may want to get rid of the part:</P><P><EM>PERIOD={'Apr','Aug','Dec','Feb','Jan','Jul','Jun','May','Nov','Oct','Mar','Sep'}</EM></P><P><SPAN>That way you'll also enable users to select which PERIODS they want to see or use for that formula.</SPAN></P>Wed, 17 Jul 2019 15:40:56 GMThttps://community.qlik.com/t5/New-to-Qlik-Sense/I-have-a-set-analysis-that-I-would-like-to-use-filters-to-affect/m-p/1603293#M141399Carlos_Reyes2019-07-17T15:40:56ZRe: I have a set analysis that I would like to use filters to affect the restults
https://community.qlik.com/t5/New-to-Qlik-Sense/I-have-a-set-analysis-that-I-would-like-to-use-filters-to-affect/m-p/1603315#M141402
<P>I understand what you are saying, and it makes sense from my understanding of the documentation, but when I replace the 1 with a $, my result now displays 0.</P>Wed, 17 Jul 2019 16:33:20 GMThttps://community.qlik.com/t5/New-to-Qlik-Sense/I-have-a-set-analysis-that-I-would-like-to-use-filters-to-affect/m-p/1603315#M141402gwmills_fiserv2019-07-17T16:33:20ZRe: I have a set analysis that I would like to use filters to affect the restults
https://community.qlik.com/t5/New-to-Qlik-Sense/I-have-a-set-analysis-that-I-would-like-to-use-filters-to-affect/m-p/1603320#M141405
<P>In that case I'd identify which part of the formula is making it to show a 0. For instance, I'd start with:</P><P>=sum({$<[SCHEDULE LINE DESC]={'7041100 Cons Lns - Annual Fees Ploc','7048100 Comm Non - RE - Annual Fees','7046100 Comm RE Ln - Annual Fees Loc'}>}Value)</P><P>And see if that formula returns a result different than 0, if so, I'd add the next filter:</P><P>=sum({$<[SCHEDULE LINE DESC]={'7041100 Cons Lns - Annual Fees Ploc','7048100 Comm Non - RE - Annual Fees','7046100 Comm RE Ln - Annual Fees Loc'},[SCHEDULE NAME]={'Income Statement'}>}Value)</P><P>and again, confirm the result is different than 0, and so... until you can identify which filter inside the set analysis section is making the formula show a 0 result. Once you know which filter is the root cause, you can explore your data to understand if the filters you want to combine make sense or maybe the formula is showing a 0 when the filters you select don't share an association with the filters you use in your formula.</P>Wed, 17 Jul 2019 16:58:37 GMThttps://community.qlik.com/t5/New-to-Qlik-Sense/I-have-a-set-analysis-that-I-would-like-to-use-filters-to-affect/m-p/1603320#M141405Carlos_Reyes2019-07-17T16:58:37Z