Discussion board where members can get started with QlikView.
I have an issue where users need to exclude an account code only for a certain year.
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
([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.
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?
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