Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
userid128223
Contributor

master calender based on 2 dates in fact table

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

  1. I want to create one master calander with combination of both dates.
  2. 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

7 Replies
userid128223
Contributor

Re: master calender based on 2 dates in fact table

Any help with this anyone.

Re: master calender based on 2 dates in fact table

Hi

   Please find the solution in attachment.

   Hope this is what you want.

Regards,

Kaushik Solanki

userid128223
Contributor

Re: master calender based on 2 dates in fact table

Thanks Kausik

your solution dont work as 2 tables are not linked.

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

userid128223
Contributor

Re: master calender based on 2 dates in fact table

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

HI,

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

   Will you please elaborate with an example.

Regards,

Kaushik Solanki

userid128223
Contributor

Re: master calender based on 2 dates in fact table

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.

Not applicable

Re: master calender based on 2 dates in fact table

Hi amiumi66,

I have the same problme as you.

Have you found any solution for that?

Regards,

Ivelin