Button Actions - Select in Field

[#1]

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

[CELAMBARASAN]

Can you post sample qlikview file?

[#3]

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/>

[IAMDV]

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

www.QlikShare.com