topic Independent date picker that will still filter selections in QlikView

Independent date picker that will still filter selections

Mon, 12 Oct 2015 17:32:48 GMT

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.

Qrishna — Mon, 12 Oct 2015 17:46:31 GMT

post a demo document with some sample data.

Thanks

Mon, 12 Oct 2015 18:10:35 GMT

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.