topic Set Analysis Help in QlikView

Set Analysis Help

Anonymous — Sun, 30 Nov 2014 19:15:13 GMT

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

Re: Set Analysis Help

m_woolf — Sun, 30 Nov 2014 22:06:51 GMT

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

Re: Set Analysis Help

Anonymous — Mon, 01 Dec 2014 09:38:47 GMT

Hi,

It is not working.

-Jay

Re: Set Analysis Help

SunilChauhan — Mon, 01 Dec 2014 09:40:00 GMT

check format of both Date

it should be same

Re: Set Analysis Help

Anonymous — Mon, 01 Dec 2014 09:44:52 GMT

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

Re: Set Analysis Help

SunilChauhan — Mon, 01 Dec 2014 09:49:41 GMT

attached sample if possible

Re: Set Analysis Help

tresB — Mon, 01 Dec 2014 09:51:49 GMT

Try something like:

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

Re: Set Analysis Help

Anonymous — Mon, 01 Dec 2014 09:55:58 GMT

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

Re: Set Analysis Help

giacomom — Mon, 01 Dec 2014 09:57:11 GMT

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

Re: Set Analysis Help

Anonymous — Mon, 01 Dec 2014 10:10:51 GMT

Hi Tresesco,

It didn't worked for me.

Re: Set Analysis Help

Anonymous — Mon, 01 Dec 2014 10:28:26 GMT

Hi Giacomo,

Due to my data Model, I cant rename and link with Master Calendar. If I rename, I will get circular reference. That's why I am keeping separately.

Re: Set Analysis Help

giacomom — Mon, 01 Dec 2014 10:57:19 GMT

Okay I see,

I tried with a simple example here: the calendar object uses the Master Calendar date field "Ref_Date", and the chart expression is =Sum({$ <Date=Ref_Date>} Amount).

The only thing is that you have to select at least one date to make the chart display a result.

Otherwise you can solve this by modifying the expression like =Sum({$ <Date=P(Ref_Date)>} Amount)

to get the results even when you don't select any date from your Master Calendar.

I hope this helps,

Giacomo