topic Master Calendar Range Problem in QlikView

Master Calendar Range Problem

Sat, 26 Feb 2011 13:45:40 GMT

Dear All,

I have data with start and end date. I have connected the master calender to my fact table over start date. If one of the mesguliyet_kodu doesn't end on the started month I have a problem. For example when I select "II" mesguliyet_kodu, it started on 18th April (Nisan) but ended on 5th May (Mayis). So the total day between end and start date is 17. But I want to see it 12 on April and 5 on May.

How can I succeed it?

Hope to hear you soon.

Best Regards,

Asim Akin

Master Calendar Range Problem

llauses243 — Mon, 28 Feb 2011 05:17:00 GMT

Hi,

My offer is by script, pls see image & zip atached

Good luck, Luis

Master Calendar Range Problem

Mon, 28 Feb 2011 15:54:04 GMT

Dear Luis

Thanks for your solution. However AY field makes loop on the table structure because I have anothter table that I didn't sent you in my example. Please see the attached error messages. Is it possible to fix it?

Master Calendar Range Problem

llauses243 — Mon, 28 Feb 2011 16:56:02 GMT

Hi,

This is my schema (see image attached), no match with your schema, then is for me other case

Send me your .qvw thanks, Luis.