topic Common Calendar issue in QlikView

Common Calendar issue

arpitkharkia — Thu, 24 Oct 2019 13:23:14 GMT

Hi All,

I have 3 transaction tables which link up with each other associativity based on a mapping table. I have attached the spreadsheet which contains the transaction tables and the mapping table.

My problem is that i am not able to create a common calendar for the dates present in the transaction tables. I saw a few solutions on the community but still unsuccessful in implementing those in my scenario. Please let me know if there is any confusion in understanding this scenario, i will try to create an app.

Any kind of help and advise will be appreciated. Thanks!

Regards,

Arpit

Re: Common Calendar issue

Arthur_Fong — Fri, 25 Oct 2019 04:16:17 GMT

Concatenating those 3 transactions table seems to be a better way of doing this:

Then, you can select the transactions you would want to view(1,2,or 3), which is the result of concatenation of the 3 transaction tables using the same column name.

MasterCalendar is created once the tables are concatenated together.

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

Re: Common Calendar issue

Brett_Bleess — Mon, 04 Nov 2019 19:22:42 GMT

Arpit, did Arthur's post with his sample app get you what you needed? If so, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit and let others know this worked. If you are will working on things, leave an update.

Regards,
Brett