topic Re: Handling of multiple PERIOD fields in QlikView

Handling of multiple PERIOD fields

spcon2016 — Fri, 06 Oct 2017 08:56:22 GMT

Hello Community,

I need your help one more time.

I think everyone meets this challenge at least once in his Qlik-Career.

- more than 5 tables

- each one of them has its own PERIOD field

- each table has an ID as key field, so I'm mapping the tables through the ID

- to avoid synthetic keys, I did rename every single PERIOD field

- and now, I'm not able to show the values of 2 different tables in one Chart (for example: Line Chart)

I thought about MASTER CALENDAR, but really do not know if that would be best practice.

Could anyone guide me through the right Approach, please?

Best regards

K.K

tresB — Fri, 06 Oct 2017 09:09:31 GMT

In such scenario, you could try implementing canonical date concept. Read it here: Canonical Date

YoussefBelloum — Fri, 06 Oct 2017 09:40:25 GMT

Hi,

You can also try to implement a LinkTable.

take a look at this thread, it answer axactly your question !