topic Re: Calendar object to pick multiple date types in QlikView

Calendar object to pick multiple date types

Wed, 25 May 2016 11:36:02 GMT

Hi Guys,

In my data model I have more then 10 different Date Types.

I have created 2 calendar objects to pick 'To' & 'From' dates

What am I trying to do..

I want the Users to chose type of date when they select 'To' & 'From' form the calendar object.

Example:

If user selects date type as 'Delivery Date' then it should only show orders delivered within selected date range.

If user selects date type as 'Shipping Date' then it should only show orders shipped within selected date range.

I have attached sample QVW with sample QVD with sample data set.

About the attached Application..

I have created a date link table and then created a master table.
Two variables as 'vStartDate' & 'vEndDate' to select min and max date from common date field called 'Date'
Every time variable changes, a trigger will make selection in the 'Date' Field in Master Calendar

Thank you in advance for your time, ideas and advice

Re: Calendar object to pick multiple date types

MarcoWedel — Wed, 25 May 2016 14:31:11 GMT

Maybe using dollar sign expansion with a variable or field to switch between date types.

Regards

Marco

Re: Calendar object to pick multiple date types

marcus_sommer — Wed, 25 May 2016 14:32:22 GMT

If you want to switch between different date-fiels you could use dimension-groups and/or some kind of visibility-conditions triggered per selections/variables or buttons.

But have you looked for a way to combine these different date-fields, like in this way: Canonical Date?

- Marcus

Re: Calendar object to pick multiple date types

MarcoWedel — Wed, 25 May 2016 21:48:37 GMT

Hi,

maybe like this:

tabDatTypSelIsland:
LOAD Distinct [Date Type] as DateTypeSelect
Resident DateLink;

hope this helps

regards

Marco

Re: Calendar object to pick multiple date types

Thu, 26 May 2016 12:22:40 GMT

Thank you guys.. I had the hide/show though in mind but I was hoping that someone might have achieved it without having multiple calendar object in the document.

Is it possible in the calendar object to pick date based on date type selection? like using an if Statement in the calendar field ?

Re: Calendar object to pick multiple date types

marcus_sommer — Thu, 26 May 2016 12:36:07 GMT

The suggestion from marcowedel covered exactly what do you asked for.

- Marcus

Re: Calendar object to pick multiple date types

MarcoWedel — Thu, 26 May 2016 22:44:03 GMT

Hi,

like Marcus said, that's what I tried to do.

However, I noticed that Marcus' proposed solution using a dimension group seems to be more straight forward, so you might want to try this as well.

hope this helps

regards

Marco

Re: Calendar object to pick multiple date types

Sun, 29 May 2016 07:15:31 GMT

Thanks Marco,

But I am still confuse about 'To' & 'From' Date

If user selects date type is order date then he should be able to pick a start date and an end date.

So as an example.. User may want to know Order Placed between 01/May/2016 to 20/May/2016 and delivered between 21/May/2016 to 25/May/2016

How can we make selection in field based on two calendar picker?

Re: Calendar object to pick multiple date types

Anil_Babu_Samineni — Sun, 29 May 2016 08:47:10 GMT

Try this for last issue..

=Only({<OD = {'>=05/11/2015<=03/01/2016'}>}OA)

Or else try this reference..

Creating Reference Dates for Intervals

https://community.qlikview.com/servlet/JiveServlet/download/948275-205389/Community_199024.qvw

Re: Calendar object to pick multiple date types

Peter_Cammaert — Sun, 29 May 2016 10:52:49 GMT

Use a search expression in your trigger action expression field. Like

>=$(vStartDate)<=$(vEndDate)

Make sure that the replacement values from the two variables correspond to the content of the Date field.

If you want to know the exact expression syntax, try to obtain a from/to range selection in the search field of the Date listbox. Copy that one to the trigger value and replace the date parts with the variable expansions.

Peter

Re: Calendar object to pick multiple date types

Peter_Cammaert — Sun, 29 May 2016 13:04:23 GMT

I may have simplified the whole logic a bit too much, but the example below does everything using variables and expressions (and a few buttons). The trick in this example is that Select field and Clear field actions allow you to embed a $-sign expansion in the target field name. Using a variable to select the date field from a predefined (i.e. hard-coded) list, does away with everything in the master calendar and the link table. Of course you'll need those two for other uses like set analysis and such.

Note: if you don't like the extra selection step using a GO!-button, copy its action back into the calendar field event triggers and drop the button. I did remove the variable actions because I don't really like the automatic propagation of special "artificial" selections.

Also note that I applied a different min/max date expression for the two calendar objects, as to not let them end up on the wrong side (like Start Date > End Date). If you don't like that approach, change them back to your default logic.

Best,

Peter

Re: Calendar object to pick multiple date types

mithunr40 — Thu, 21 Jul 2022 10:00:01 GMT

Hi Peter,

I have one dought in vDateSelection variable what logic you have written.

I am not able to understand.

Please help

Thanks