topic Re: Static 'Year' Filter in a text box in QlikView

Static 'Year' Filter in a text box

agajendra — Sat, 16 Nov 2024 01:45:26 GMT

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!

Re: Static 'Year' Filter in a text box

bharathadde — Fri, 06 Dec 2019 17:43:37 GMT

Try this

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

Re: Static 'Year' Filter in a text box

Brett_Bleess — Mon, 16 Dec 2019 22:34:28 GMT

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