Hello again, I am hoping you can help me with this as well.
I am trying to visualize appointments in Qlik, but I am having some trouble because in the database appointment descriptions can either be found in the text table or in the document table, and the appointment type can either be found in the task table or in the doctmpl table. So when I want to visualize this I have to find the appointment description either in the text table or in the document table (depending on the type of appointment). However I cannot find a way to find the type of appointment if this is a document, because I cannot find a way to link the doctmpl table with either the appointment table or the document table. Is there some way to do this?
Thank you in advance.