Static 'Year' Filter in a text box

[agajendra]

Hello,

I am trying to create a Report card where I want to show Total for the Year and Month.

=num(Sum(${<py_f={1}>}Amount), '$#,##0.##') - for the Previous Year

=num(Sum(${<pm_f={1}>}Amount), '$#,##0.##') - for the Previous Month.

I have a list box to filter out different months. But I want to keep the Year Total constant while switching between Months.

And I also want to see these totals for different Suppliers selected from a search box.

Thanks!

[bharathadde]

Try this

=num(Sum(${<Month=,py_f={1}>}Amount), '$#,##0.##') 

[Brett_Bleess]

If the posters comment helped you get your use case working, please be sure to return to the thread and use the Accept as Solution button on their post to give them credit for the assistance and let other Community Members know that solution worked.  

Here are some Set Analysis Design Blog posts that might be useful, and the last link is the base URL to the Design Blog area in case you want to search further on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Hopefully these may be of some use, there are others on Set Analysis, but the one seemed to be the most pertinent in this case.  If you use the second URL and use Set Analysis as your search term, you will see all the posts related to it, and I expect you will likely find what you need there if the other post did not do the trick.

Regards,
Brett