Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Creator III
Creator III

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

Labels (2)
5 Replies
dilipranjith
Partner
Partner

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
Creator III
Creator III
Author

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
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
davyqliks
Creator III
Creator III
Author

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
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.