Using Buttons to select in field

[davyqliks]

Hi,

I have an issue where users need to exclude an account code only for a certain year.

E.g. 

Select in field [Account Code] for  (12346|679954|855555)

but only for [Year] ='2019'

However, i do not want to filter on 2019, only apply the select in field selection to the year 2019.

In the data load i am excluding Account codes but this is the first time i need to exclude based on a separate parameter.

Is it best to do this with a button, or, is it possible to 

Load

([Account Code]=('61100000000') or Len(Trim([Account Code])) = 0 ) and base this only on a year?

Thank you, any advise on how to exclude data for set account codes based on year (without filtering out the other years) would be much appreciated.

Thanks

Daniel

[dplr-rn]

Not clear on your problem. you mention button but all examples point to load statements in script

Do you want to do this in the script? or in the dashboard?

[davyqliks]

Hi,

Thank you.... I wanted to perform this in the script but cannot work a solution.

I assumed a button may work best but to be honest, if it can be accomplished in the script that would be ideal.

I was looking for a solution in either method to exclude certain account codes for only  1 year.

Thank you for your time

Daniel

[Brett_Bleess]

Daniel, have a look around in the Design Blog area, there are 700+ posts from our internal experts in this area, most are how-to related, so that may give you some ideas.  I am not really sure where to point you on this one, so just going to let you go search around on your own to see if you can find some things to give you some ideas.

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

Regards,
Brett

[davyqliks]

Hi,

Thank you for taking the time to look at this. I will search those links to see if i can find a suitable solution.

Daniel

[Brett_Bleess]

I think you likely want to try Set Analysis on this one, but I am not sure, there is a good Primer on Set Analysis blog post, but there is also one specific to dates in set analysis that may be what you need....

Cheers,
Brett