topic problem with calendars in QlikView

problem with calendars

Fri, 24 Feb 2012 15:22:31 GMT

Hi everyone,

i have a problem with an aplication which has diferents calendars and i need to unified those calendars in one to select just one date.

For example in the application im going to attach if i select a month in CALENDARIO_ERP_MOVIMIENTO.MES all others Calendars should be in the same month too. So if i have sales and subscriptions and i select just one time january, the application give me the values of january for sales and subscriptions. Now i need to select january for sales and then january for subscriptions.

Thanks for any advice

Gerardo

Re: problem with calendars

swuehl — Fri, 24 Feb 2012 16:06:46 GMT

I can't see any data in your attached file, have you reduced data before saving?

I see the table view though:

You are using several calendar tables, as you already said, but some seem to be data islands. There is no linking between data islands, so a selection in a field in one island will not affect the selection state in a different island.

Even if your calendars are linked (I think some of them are), they seem to be linked by a key. Let's assume you are using something like a OrderID and calendar for Shipment and Order. For any OrderID, the date / month that this OrderID is linked in the Shipment calendar must not be the same as in the calendar for the orders (you could order last year december, but still waiting for the shipment...) So a selection in a month in any calendar that is linked via key(s) to another calendar does not necessarly lead to a selection state in the second calendar that is duplicating the first selection as possible selection.

If you want to synchronize the selection of one calendar with others, you could use triggers and actions.

Create a trigger on select and/or change in your master calendar field (e.g. Mes) in document properties and create one or more actions Select /Select in field for the other calendars.

Hope this helps,

Stefan

edit:

I've seen that you've uploaded another file, but I am not going to download some 40 MB, since I don't think this will give me any more insight.

Re: problem with calendars

Fri, 24 Feb 2012 16:43:23 GMT

Hi Stefan,

Sorry i attached again a clear versión about i need in the .qvw “Tablero” with values..You will see if you select Ene-2011 in Calendario_subscriptions.añomes no one is select in calendario_deal_externals.añomes.

i have multiple calendars but only i need a master one to use and to select months.

Could you please give an example of the trigger you said?

Thanks

gerardo

problem with calendars

swuehl — Fri, 24 Feb 2012 16:52:53 GMT

Gerardo,

here is a nice discussion about the possible solutions for a selection copy, including some samples:

http://community.qlik.com/message/149230

Regards,

Stefan

Re: problem with calendars

Fri, 24 Feb 2012 18:23:06 GMT

Hi Stefan,

I saw the discussion and it could help me.

Last question…..this is the way to design a master calendar or a solution to my issue?

thanks

De: swuehl

Enviado el: viernes, 24 de febrero de 2012 01:53 p.m.

Para: Pauza, Gerardo

Asunto: - Re: problem with calendars

QlikCommunity <http://community.qlik.com/index.jspa>

Re: problem with calendars

created by swuehl <http://community.qlik.com/people/swuehl> in New to QlikView - View the full discussion <http://community.qlik.com/message/195435#195435

problem with calendars

swuehl — Fri, 24 Feb 2012 18:50:49 GMT

I would consider this a solution to your issue, not a general approach (and a solution only if I got your problem correctly).

You could use the copy selections technique if you need to synchronize the calendars. But keep in mind that e.g. copying the selection from orders calendar Mes field to shipment calendar Mes field now probably limit your data to the orders that have been ordered and shipped in one Month.

So first of all, you should think about which fields you really need to see and select on, and how this should affect the data you see. It's not an easy task, but really important before you can decide how your data model needs to look like.

Have a nice weekend,

Stefan

Re: problem with calendars

Fri, 24 Feb 2012 18:52:40 GMT

Thanks. Have a nice weekend you too.

gerardo

De: swuehl

Enviado el: viernes, 24 de febrero de 2012 03:51 p.m.

Para: Pauza, Gerardo

Asunto: - Re: problem with calendars

QlikCommunity <http://community.qlik.com/index.jspa>

Re: problem with calendars

created by swuehl <http://community.qlik.com/people/swuehl> in New to QlikView - View the full discussion <http://community.qlik.com/message/195483#195483