Number of rows in straight table used in calculation condition
I am writing with a question on how we can get the total number of rows in straight table and use that as part of calculation condition? Basically, I want to be able to limit the straight table to only show if there are 50K or less rows in that straight table not on my result set after filters (elaborated on Dynamic table sub-point)
I have 2 tables where I want to implement this:
Static table - dimensions and expressions are static. This has 8 dimensions.
Dynamic table - user has the ability to choose what dimensions or expressions they want to display, can go up from 1 to 32 dimensions.
Using just the number of rows returned by filters will not work in this situation in the case where a user selects dimensions and only returns 2 values, I want to still show that even if the dataset rows is still >50000 after any filters applied.
Things I've tried:
NoOfRows(TOTAL) - this doesn't seem to return the total number of rows when used outside of the expressions tab of that table so doing NoOfRows(TOTAL) <=50000 on the calculation condition doesn't work.
RowNo() - or other variations of this function also doesn't work for my use-case, pretty much same as NoOfRows
Also tried using it in the script to put a row number for my records, doesn't really work for me because of the scenario mentions in the Dynamic table sub-point.
Count(Distinct dimension1 & ... & dimensionN) - this one works for the static table although I notice significant slow down with 8 dimensions being processed.
I tried this same logic for the dynamic table but QlikView crashes due to lack of memory, I imagine because of the number of fields I try to concatenate (32).