Appreciate your time. I am getting a time out issue while opening a chart in QlikSense. Below is our data model
store table-->fact_Total table--> Fact table-->product table
so my dimension for the chart is store_id from store table and measure is count(distinct uss_id) from the product table , I am getting a time out issue.
I tried creating another small table from product_table and created sum(uss_id) for my measure but still we have time out issue.
Very hard to judge with the limited information. I would hazard a guess saying check the link between store to fact total to fact Table. Is it working correctly when you just filter values?
Appreciate your time. your assumptions is right. The store is connected to fact via total_fact. I need this for some other calculations in my dashboard.
Again, the link b/t fact and total fact is a big key with concatenations of 5 fields.
The b/t store and product table we have fact and total_fact tables.
