topic Re: Master calendar and Filtering problem in QlikView

Master calendar and Filtering problem

Mon, 22 Sep 2014 21:03:41 GMT

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.

Re: Master calendar and Filtering problem

Anonymous — Tue, 23 Sep 2014 06:58:05 GMT

check this

Re: Master calendar and Filtering problem

Tue, 23 Sep 2014 12:47:07 GMT

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.

Re: Master calendar and Filtering problem

arniewolff — Tue, 23 Sep 2014 16:57:12 GMT

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

Re: Master calendar and Filtering problem

Wed, 24 Sep 2014 20:06:48 GMT

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?"

Re: Master calendar and Filtering problem

arniewolff — Wed, 24 Sep 2014 20:28:39 GMT

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

Re: Master calendar and Filtering problem

Thu, 25 Sep 2014 12:42:42 GMT

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.