Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Set Analysis Help

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

11 Replies
Highlighted
Honored Contributor II

Re: Set Analysis Help

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

Highlighted
Contributor II

Re: Set Analysis Help

Hi,

  It is not working.

-Jay

Highlighted
Esteemed Contributor

Re: Set Analysis Help

check format of both Date

it should be same

Highlighted
Contributor II

Re: Set Analysis Help

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

Highlighted
Esteemed Contributor

Re: Set Analysis Help

attached sample if possible

Highlighted
MVP
MVP

Re: Set Analysis Help

Try something like:

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

Highlighted
Contributor II

Re: Set Analysis Help

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

Partner
Partner

Re: Set Analysis Help

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

Highlighted
Contributor II

Re: Set Analysis Help

Hi Tresesco,

      It didn't worked for me.