Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Independent date picker that will still filter selections

I am trying to create a date picker that allows me to pick any date but also filter my list boxes by that date.

I set a variable called vSelectedDay to set the date.   The range for my dates are min/max(Date(ProcessDate).

I have a List Box that show Salespeople.   I want that list box to filter all those salespeople that have sales on the ProcessDate.

If I do a trigger to on the vSelectedDay variable to "Select in Field - ProcessDate=vSelectedDay", my Salesperson list filters fine.

The problem is that my DatePicker now is stuck on the Selected Day until I do a "Clear Selections".

My app is large and complicated, so it is hard to upload but I can provide Screenshots if that does not make sense.

2 Replies
krishna_2644
Specialist III
Specialist III

post a demo document with some sample data.

Thanks

Not applicable
Author

Report in question is the First report - Daily Sales

Right now i have triggers set on the Sheet Open properties to Select in Field - Date_ProcessDate = vDate_Selected.

vDate_Selected is originally set by my script to max(Date_ProcessDate)

I then have triggers on the variable vSelectedDay to set Select in Field - Date_ProcessDate = vDate_Selected.