topic Use Date Picker without date fields in QlikView

Use Date Picker without date fields

AnjalK — Fri, 14 Jan 2022 14:22:46 GMT

Hi,

I want to create a Date filter using the date picker. However, I don't have one single date field that I want to associate this filter to. There are two KPIs that I want to control using this filter:

1. Active Learners: Learners who visited our website in the selected time frame. The dependent date field is lastLoginDate

2. Course Completion: Learners who completed the course in the selected time frame. The dependent date field here is CompletedOn

Can someone please share a relevant article/Thread where multiple KPIs are controlled through a single date filter?

Re: Use Date Picker without date fields

rwunderlich — Fri, 14 Jan 2022 19:46:03 GMT

You'll need to link a new common date field to both dates. See here for a tutorial and downloadable examples:

https://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob

Re: Use Date Picker without date fields

PrashantSangle — Sat, 15 Jan 2022 13:03:32 GMT

create island date table, which will not be connected to any table and you can use that date field for calender