Row Count in Dynamic Straight Table

[SteffenO]

Hi,

we've got the following problem:

- Straight Table where the user can select the Columns which are displayed in the straight table

- The possible selections are up to 30 Dimensions and 20 Measures

- We want to show the table only, if the row count is below 100.000 rows

Normally I would use getselectedcount on an Field that is always present, but with the user selecting the columns that is not possible. 

Any Idea how to:

- Get the row count of a straight table into an variable

- Get the NoRows outside of an straight table

Thx for your help.

[JHuis]

i would make a field inside the table blank. (backscreen is white so i give the field that color)You then could use the same formula to do this

[rwunderlich]

You can't directly get the count of rows in a chart before you decide to calculate it. I assume you have some mechanism where the user is selecting dimensions from a list. You can make your calculation condition a count of the distinct count of selected dimensions. Something like:

Count(DISTINCT Dim1 & Dim2 & DIM3) < 100000

For example, if you are picking your dimensions from a field named "Dim", you can form the calculation condition dynamically with:

Count(DISTINCT $(=Concat(Dim, '&'))) < 100000

A warning, this type of expression can be very slow depending on your data. 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com