Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Master calendar and Filtering problem

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.

1 Solution

Accepted Solutions
Contributor III
Contributor III

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

View solution in original post

6 Replies
Creator III
Creator III

check this

Not applicable

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.

Contributor III
Contributor III

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

Not applicable


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

Contributor III
Contributor III

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

View solution in original post

Not applicable

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.