topic Using Calendar Objects to Create Variables in QlikView

Using Calendar Objects to Create Variables

Anonymous — Mon, 11 Jan 2016 18:29:16 GMT

Hello,

I am interested in having two calendar objects that would then create variables. The goal of this is to compare fields across a set of dates. Therefore, I would like the first calendar object to set the first date while the second creates another variable for the second date.

Any thoughts on how I could get this to work?

Thank you!

Re: Using Calendar Objects to Create Variables

marcus_sommer — Tue, 12 Jan 2016 10:41:25 GMT

You don't need to create variables for this. You need only two variables like vStart and vEnd and use them within your calendarbox (with min/max-date + date-formats). Then you have two options - one is to use an field-selection action triggered by changes on the variable and the other ist o use set analysis filter within your expressions like:

sum({< Date = {">='$(vStart)'<'$(vEnd)'"}>} AnyValue)

This is slightly different but I think it's helpful, too: Selecting Arbitrary Date Ranges - YouTube

- Marcus

Re: Using Calendar Objects to Create Variables

Anonymous — Tue, 12 Jan 2016 19:19:04 GMT

Let's say I have a field "Year", which I use as my calendar selection field.

How do I use what is selected in each calendar object in an expression or as a field in a table I create?

Re: Using Calendar Objects to Create Variables

Anonymous — Tue, 12 Jan 2016 19:23:05 GMT

In other words. I want to select from a set of dates in the calendar and have what ever date I select be a variable.

Re: Using Calendar Objects to Create Variables

marcus_sommer — Wed, 13 Jan 2016 06:29:27 GMT

I believe you are thinking this too complicated - qlikview has (regulary build) an associative datamodel by which all data are linked per key-fields. If you made a selection all available data are then included within the views and calculations (unless you used advanced techniques like alternate states or set analysis). A good starting point is this here: Get started with developing qlik datamodels

If you want to compare data against various time-periods then you should use a master-calendar and create flags for these periods, many examples to these topics could you find here: How to use - Master-Calendar and Date-Values.

- Marcus