topic Re: How to Create a TO and FROM date filter using multiple date fields from fact table in QlikView

How to Create a TO and FROM date filter using multiple date fields from fact table

fashid — Tue, 19 Apr 2016 06:34:52 GMT

Hi Friends,

I have a small application that works as a data extracting tool for users.

This application has multiple fact tables in it .

For the sake of understanding consider I have two fact tables; table A and table B .

There are several date fields in both the tables.

I have used a single date field from table A and a single date field from table B ( based on requirements) and linked them both to the master calendar .

I am using a calendar object that works as a FROM DATE and TO DATE to filter records in both the tables .

Now there is a need that the calendar filtering object should also work on multiple dates from table B.

My question is how do go ahead and solve this requirement.

Should I create multiple calendars for this or something else .

Regards,

Nadeem

Re: How to Create a TO and FROM date filter using multiple date fields from fact table

Kushal_Chawda — Tue, 19 Apr 2016 06:37:54 GMT

see this

Canonical Date

Re: How to Create a TO and FROM date filter using multiple date fields from fact table

Gysbert_Wassenaar — Tue, 19 Apr 2016 06:39:32 GMT

Perhaps this discussion helps: Tutorial - Using Common Date Dimensions and Shared Calendars

Re: How to Create a TO and FROM date filter using multiple date fields from fact table

sunny_talwar — Tue, 19 Apr 2016 08:22:37 GMT

Can you share a sample with the requirement of what is the exact need functionality wise?

Re: How to Create a TO and FROM date filter using multiple date fields from fact table

fashid — Tue, 19 Apr 2016 10:22:30 GMT

Hi Gysbert,

Thanks for your reply.

The post you mentioned deals with date feilds from different tables

I have dates from multiple tables as well as the same table

How would i solve the problem of multiple dates from the same table

Regards

Nadeem

Re: How to Create a TO and FROM date filter using multiple date fields from fact table

fashid — Tue, 19 Apr 2016 10:33:07 GMT

! !

Hi Sunny,

I have attached the sample application.

The user should basically be able to filter on ENQ_DATE or ENQ_STATUS_DATE depending upon his/her requirement .

For example when the user selects the ENQ_DATE then the FROM DATE and TO DATE objects SHOULD FILTER ON THAT COLUMN IN THE TRACKERS and when ENQ_STATUS_DATE is selected in the list box the results should be filtered for that column in the trackers .

Regards,

Nadeem

Re: How to Create a TO and FROM date filter using multiple date fields from fact table

sunny_talwar — Tue, 19 Apr 2016 10:41:17 GMT

See if the attached is doing what you wanted

Re: How to Create a TO and FROM date filter using multiple date fields from fact table

fashid — Tue, 19 Apr 2016 11:10:58 GMT

hi Sunny,

Appreciate your efforts but this is not what i want .

I have updated the application now and attaching it here .

Let me make it more simple.

In the application the JOB_DATE from job_tracker table and ENQ_DATE from enquiry_job_tracker table both are tied to the master calendar as DATE_KEY because the user wants to run the tracker on these dates

Now the user also wants to run the enquiry_job_tracker table with ENQUIRY_STATUS_DATE .

how do i go about doing this

I hope you got my requirement

Regards,

Nadeem

Re: How to Create a TO and FROM date filter using multiple date fields from fact table

Gysbert_Wassenaar — Tue, 19 Apr 2016 14:22:36 GMT

Same difference. Just pretend the table is two separate tables.