Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have two date-related fields: day_of_year_activity (numbered 1-365) and day_of_year_lead_created (numbered 1-365).
I am trying to create a button action will allow me to select values in a straight table only when: day_of_year_activity-day_of_year_lead_created=0...in other words, when the day an activity was recorded is the same day that the lead was created.
To try and solve this problem, I created an expression named 1Day that says: =day_of_year_activity-day_of_year_lead_created
I then tried to use a button, action, select in field to pick only the rows where the 1Day expression is 0. It is not working. I click on the button, and nothing happens. Can anyone help, please?
Thank you!
Stephen
Can you post sample qlikview file?
Unfortunately, I am not authorized to share our files. What kind of info are you looking for?
Stephen Williams
Financial Analyst
A Place For Mom, Inc.
1300 Dexter Ave N
Seattle, WA 98109
Phone: 206-802-1612
E-Mail: stephenw@aplaceformom.com<mailto:stephenw@aplaceformom.com>
Website: www.aplaceformom.com<http://www.aplaceformom.com/>
Hi Stephen,
I think the issue is with the button action/trigger. I mean you need to use the right search expression because we are evalauating the fields. I'd use something like this...
='=day_of_year_activity - day_of_year_lead_created = 0'
You might need to adopt this idea and build according to your requirement.
Also, I'm attaching a simple example for your understanding.
Cheers,
DV