Master calendar and Filtering problem

[#1]

Here is my problem.

I have 2 sets of data that I call "purchase plan" and "Purchase actuals." With the data, I need to form a graph showing both in monthly basis as attachment shows. (please open and refer to the attachment)

Those two have thier individual date fields, therefore, I had to utilize Master calender in order to have them on a graph.

Utill this stage, everything was fine, and it worked GREAT! However, when I filter them by its type, it gave me a numbers which did not make sense.

If I filter it by "Cal_Report_Prjname," it gives right number for Actual but not Plan.

If I filter it by "Cal_Report_Prjname_2," it gives right number for Plan but not Actual.

Can anyone please let me know how can I make a perfect filter that will give me a right number for both Plan and Actual?

Thank you.

[Anonymous]

check this

[#3]

Thank you, Konstantins.

But, by chaning dimension, the whole result has been changed. I undertand what you tried to do, it makes a perfect sense. The bad thing is, however, the result need to be remained as the same.

Thank you again.

[arniewolff]

This solution leaves the calendar in the data but resolves the linking of tables differently. In addition, I had to adjust the calculated actuals to account for the Cal_Month field that I changed in the table import.

It seems to provide the correct result. What do you think?

Arnie

[#5]

That is a brilliant idea. It worked as the way you did. But I want to have the same field name. Is there anyway that I can have two date fields on a graph without using "Master Calendar?"

[arniewolff · Accepted solution]

You want to be able to graph 2 different date dimensions on the same graph? I'm not sure I understand a use case for that.

In QlikView, the tables only link if the names of the fields are identical, so that would be difficult.

Thanks,

Arnie

[#7]

Yeah, that is exactly what I think. I searched everywhere and googled all the time to find a way to do what I want. But it seems not going to be happen in Qlikview.

Thank you, Arnie.