Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
arpitkharkia
Creator III
Creator III

Common Calendar issue

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

2 Replies
Arthur_Fong
Partner
Partner

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

test.PNG

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

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.