Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

davyqliks
Contributor II

Using Buttons to select in field

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

2 Replies
Partner
Partner

Re: Using Buttons to select in field

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
Contributor II

Re: Using Buttons to select in field

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