topic master calender based on 2 dates in fact table in QlikView

master calender based on 2 dates in fact table

userid128223 — Thu, 26 Jul 2012 15:33:17 GMT

Attach I have qvw that has inline table containing 2 different dates.

I want to create one master calander with combination of both dates.
Master Calander should have connection with inline table so that when i create month, Year selector, I can show corresponding data.

I have dealt with creating master calander from one date, however creating from 2 dates is confusing me.

is it possible to this via set analysis or script. please help

Re: master calender based on 2 dates in fact table

userid128223 — Fri, 27 Jul 2012 16:13:03 GMT

Any help with this anyone.

Re: master calender based on 2 dates in fact table

kaushiknsolanki — Fri, 27 Jul 2012 18:49:37 GMT

Please find the solution in attachment.

Hope this is what you want.

Regards,

Kaushik Solanki

Re: master calender based on 2 dates in fact table

userid128223 — Fri, 27 Jul 2012 19:45:42 GMT

Thanks Kausik

your solution dont work as 2 tables are not linked.

I was thinking of just concatinating 2 dates would that work.

Re: master calender based on 2 dates in fact table

userid128223 — Fri, 27 Jul 2012 20:23:14 GMT

what i want is something like this

one master calander that has all the dates from both date field which will link.
i also wanted to have some kind of flag for where to be able to called 1 date field vs other if required. or both.

Re: master calender based on 2 dates in fact table

kaushiknsolanki — Sat, 28 Jul 2012 17:45:16 GMT

HI,

I am Sorry but the requirement is still not clear to me.

Will you please elaborate with an example.

Regards,

Kaushik Solanki

Re: master calender based on 2 dates in fact table

userid128223 — Sat, 28 Jul 2012 18:07:56 GMT

Date-1 Date-2 ID

1) Date 1 + Date 2 (all dates combined) into a calander Day, year, month field. Which is linked to table and will show data as per dates selected. it will show match from both Date1 and Date2.

2) 3 flags created

1) Date 1 only found

2) Date 2 only found

3) Both found.

Re: master calender based on 2 dates in fact table

Mon, 29 Oct 2012 10:06:36 GMT

Hi amiumi66,

I have the same problme as you.

Have you found any solution for that?

Regards,

Ivelin