topic Re: Multiples Date handling in QlikView

Multiples Date handling

pkpandey — Mon, 26 Jan 2026 18:19:17 GMT

Hi all

I have made several charts based on the multiple Dates. I am not maintaining any calendar. Now my clients requirement is when u click on the bar charts it will show the details of the charts in the following chart where Month/Week/Date (depends on selection) as a dimension of whole data in the table. How to do that. Its very-very urgent.

Re: Multiples Date handling

alexandros17 — Tue, 01 Mar 2016 09:37:39 GMT

Create a separate calendar and manage your dates with set analysis,

If you have a calendar for ex. month and week unlinked to other tables if a user select month or week then in set analysis you can write:

Sum({$ <myweek={'$(=getfieldselections(week))'}>} myvalue)

let me know

Re: Multiples Date handling

pkpandey — Tue, 01 Mar 2016 09:42:04 GMT

I am using several dates e.g Moves_date, Arrival_Date, Start_Date, Due_date etc. Can u give me some idea based on which date I should make the Calendar.

Re: Multiples Date handling

alexandros17 — Tue, 01 Mar 2016 09:56:39 GMT

None of them, you have to create a new calendar starting from min date to mad date among all dates

Re: Multiples Date handling

pkpandey — Tue, 01 Mar 2016 10:00:10 GMT

i shall be very kind of you if u please send me an example.

Re: Multiples Date handling

alexandros17 — Tue, 01 Mar 2016 10:23:46 GMT

Here it is, let me know

Re: Multiples Date handling

Anonymous — Tue, 01 Mar 2016 10:32:06 GMT

Did you check this?

Canonical Date

Re: Multiples Date handling

pkpandey — Fri, 04 Mar 2016 03:28:58 GMT

Hi Balraj

Thank you for your reply. My requirement is when user selects a week the selected charts should be displayed with a time dimension of week (all the weeks) and on date selection the dimension will be date. and I am using more than two measures on different dates.

Re: Multiples Date handling

jonathandienst — Fri, 04 Mar 2016 05:20:45 GMT

Yes, and if you read the article that Balraj sent you, you will see exactly how to do that.