topic Re: master calendar loading in QlikView

master calendar loading

Wed, 20 Jun 2012 21:29:18 GMT

hi,

I have got a loading issue, I don't have any idea to load my data.

I need to have a calendar to select a date and 2 pivot tables based on 2 differents dates (date1 and date2).

If I select the 26/02/2012. Il would like to see

-in the first graph every data for date1 = 26/02/2012

-in the secondgraph every data for date2 = 26/02/2012.

Have you got any idea?

Thanks a lot

Re: master calendar loading

Jason_Michaelides — Wed, 20 Jun 2012 22:49:34 GMT

Fact:

LOAD
ID

,Date

,Amount

,'Invoice' AS Fact_type

FROM...Invoices...;

CONCATENATE (Fact)

LOAD
ID

,Date

,Amount

,'Purchase' AS Fact_type

FROM...Purchases...;

Then, in your charts you can have a dimension of Date and Expressions:

SUM({<Fact_type={Invoices}>} Amount) for Invoices and

SUM({<Fact_type={Purchases}>} Amount) for Purchases

Hope this helps,

Jason

Re: master calendar loading

Thu, 21 Jun 2012 15:44:43 GMT

Thanks, but in fact, it's the same fact. :S Do I need to duplicate all data

Re: master calendar loading

Jason_Michaelides — Thu, 21 Jun 2012 17:27:34 GMT

What do you mean, "it's the same fact"?

Re: master calendar loading

Thu, 21 Jun 2012 17:57:16 GMT

My fact have got 2 dates. In 1 graph I display by the fisrt date and in the other, I display by the second date

Re: master calendar loading

Jason_Michaelides — Thu, 21 Jun 2012 18:53:40 GMT

Can you post a sample of your source data?

Re: master calendar loading

Thu, 21 Jun 2012 20:19:58 GMT

Hi,

Please, find an example attached.

I really need to link it to others tables, I cannot leave it isolated.

Eva

Re: master calendar loading

Jason_Michaelides — Thu, 21 Jun 2012 22:42:52 GMT

I'm sorry Eva but I really don't understand what you're trying to do!

What are Date1 and Date2 in your inline table?

Re: master calendar loading

Fri, 22 Jun 2012 17:10:12 GMT

Sorry about that!! I will try to explain better.

when I pickup the date 01/01/2012 in my list.

I would like display :

-for the first graph

Dimension Date1. Value 20

-for the second graph

Dimension Date2. Value 10.

My set of data is different in both graphs.

I did it like that :

-disconnect my master calendar and data.

-make dimension with : if(master_calendar_date = date1, date1).

the behavior is ok, but performance are really bad.

Re: master calendar loading

mphekin12 — Fri, 22 Jun 2012 17:29:15 GMT

Eva,

Why do you try to split you fact table into two tables. One table for Invoices and on for Purchases then have each of these tables link to your Master Calendar.

Re: master calendar loading

Fri, 22 Jun 2012 17:35:31 GMT

because, it's the same fact, but there are 2 dates for it.