Difficulties in using a single date filter for facts with different dates

[#1]

Difficulties in using a single date filter for facts with different dates

Hello everyone, I'm a new Qlikview student and I'm breaking my head to solve a date problem. Could they help me?

I have 3 tables:

Budgeted (sales projection type) [Product Code, Budget Date, Amount Estimated]

Realized (Sale) [Product Code, Date of Sale, Quantity Sold]

Product [Product Code, Product Description]

When I set up a chart comparing the budgeted x performed, I need to select the Month dimension however if I select the Dimension month of the realized budget is wrong and vice versa ... I would need to put a single date dimension. I joined some forums but could not solve them.

As you can see in the image above, the 3rd graph is not bringing the information as it should ...

I have attached the file in which I am trying to perform the tests ...

Please, I really need some help.

Thank you

[ziadm]

You need to change data model consider using canonocal dates

Canonical Date

[aarkay29 · Accepted solution]

Chech this

[#4]

Ok I'll check this post, thank you

[#5]

I think I understood, the secret is to do a joins in a single table, to be able to perform a unique filtering of date. right?

[rupamjyotidas]

You may want to close the discussion.If your problem work out

[Anonymous]

you should have a look at the P() function, if want to avoid using canonical dates...

[#8]

I think I got it now. I want to thank you so much for helping me so aptly. You're great!

[#9]

Thanks a lot