I am still new to qlik sense and try to build an app in Qlik sense Enterprise which is a dashboard contains many indicators(KPI and PI). All the data sources are excel files which have common fields (date and place) . So i created an excel sheet as master calendar and a fact table for countries and regions. Every time I try to make a link between the tables I encounter a problem with the circular references.
I have 2 questions :
1.How can I associate these tables in a way allow me to make selection according to certain date. 2. How to show the current month on the dashboard when there is no selection.
In the attachments there are the excel sheets I am working with and a screen shot showing the problem I have.
I still have problem with selecting data according to certain month or date. I need to select a certain date and at the same time a certain region or country and show data according to these two dimensions. Still need to associate the calendar and the country_region tables with all tables to get the right selections, which gives me issue with circular references.