Set Analysis Help

[Anonymous]

Hi All,

    I am having following two tables of Master Calendar and Application Table.

    But I need to create a chart which should have the date as Dimension from Master Calendar date,that should equal to Application Date Value.

To make clearly I need to have a condition like Where MasterCalendar.Date=ApplicationDate

Kindly let me know

-Jay

[m_woolf]

if(MasterCalendar.Date=ApplicationDate,MasterCalendar.Date)

[Anonymous]

Hi,

  It is not working.

-Jay

[SunilChauhan]

check format of both Date

it should be same

[Anonymous]

Yes,both are representaed  as 'MM/DD/YYYY'

[SunilChauhan]

attached sample if possible

[tresesco]

Try something like:

Sum({<MasterCalendar.Date={"=MasterCalendar.Date=ApplicationDate"}>}Amount)

[Anonymous]

Actually I am counting the values,based on certain date period. So that date from Application table should match with master Calendar table

[giacomom]

Hi,

you can try to name the date field in your Application table the same way you have it in the Master Calendar so the chart will automatically select the equal dates.

Regards,

Giacomo

[Anonymous]

Hi Tresesco,

      It didn't worked for me.