In my way i came with some thoughts
1) May be Limited columns in Tablebox - But, I don't think limit is the problem because we can use number of columns if we have enough RAM and CPU as specification required
2) Here, I was thinking about data immigrant which has unique granularity cells of each columns. Let's consider as 3rd one
3) When we have some unique rows which is not there of another table called immigrant
4) Let's discuss, with example - If we are adding 3 columns each with 20 distinct values then qlik products calculate as 20*20*20 that means the rows efficient and increasingly.
5) What you think when you have 73 columns with 100 distinct values? Does it make sense to calculate each 100*100*100....power of 73 time as Qlik calculates. do you know what does value indicated it extend to around 1e+148 times?? So, For this i think you need Trillion GB of RAM for sure.
5) so, to resolve this issue i would always prefer to think measure (expression). Why are you using for dimensions as we have metric level aggregation to calculate
Does this helps to you?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
