topic Problem with 2 dates. in QlikView

Problem with 2 dates.

Mon, 12 Dec 2011 19:59:53 GMT

Hi Everyone,

I'm using 2 tables with a linked table between them.

The above 2 tables has date in each of them. Now, I am trying to make a straight table with Color as Dimension and Counting the corresponding ID's in different expressions from2 tables. But, I have to use the date so that when I select any month from a calendar object it should filter the results based on the 2 dates. So, i need to select just one month and year and it should just filter the 2 expressions. But, I can link onlyone of the date to my calendar object.

Thanks. any help would be appreciated.

Problem with 2 dates.

Mon, 12 Dec 2011 20:06:55 GMT

i think you have to use only one date like a dimensión, and like a filter to your qlikview.

Problem with 2 dates.

Mon, 12 Dec 2011 20:17:08 GMT

Hi Antonio,

Thanks for replying. I didn't understand what you meant by using just one date. The straight table above use COLOR as dimension. And I have a Calendar object which I can just connect to one date, and thats not gonna solve my problem.

If I just select one date, and use it to filter. It's gonna filter just one expression.

Thanks

Problem with 2 dates.

Mon, 12 Dec 2011 20:18:24 GMT

You will need to experiment adding the date fields to the link table as well, and then connect the calendar object to the link table.

Problem with 2 dates.

Mon, 12 Dec 2011 20:24:51 GMT

Hi,

Thanks for your reply. But, if I add the date field to the link table, thats gonna creata synthetic keys between these table and the Link Table. I don't know if that approach would work.

Thanks.

Problem with 2 dates.

Mon, 12 Dec 2011 20:35:16 GMT

you have something like this?:

COLOR OLD_ID_COUNT OLD_Created_Date NEW_ID_COUNT NEW_Created_Date

GOLD 307 20090101 108 20110101

Problem with 2 dates.

Mon, 12 Dec 2011 20:46:36 GMT

You would need to rename them in the link table to avoid a synthetic key.

Problem with 2 dates.

Thu, 22 Mar 2012 19:00:27 GMT

Any resolution on this problem? I have the same kind of problem.