restrict number of rows in a straight table based on an aggregate column

[#1]

Hi All,

I have s straight table with 15 columns. The first column is a field and all the other are calculated columns. The 16th column is the sum of column(1)...column(15).

I want to restrict the number of rows in the straight table based on the 16th column. If the value in the 16th column is < 20, then that entire row should be discarded from the straight table.

Would appreciate all help and tips to do this.

Thanks,

Tutan

[cesaraccardi]

Hi Tutan,

I'm not sure if I understand your requirement, if your goal is to make 80/20 analysis and you are using QV 11 you have the Dimension Limits tab that may help you with this.

Regards,

Cesar

[#3]

Hi Cesar,

All I want is to display only those rows in a straight table which has it's 16th column value greater than 20.

Not sure how can I use the dimension limit tab here. The dimension limit tab shows only the name of the dimension used.

Please help.

Thanks,

Tutan

[manisha_uit]

Hi Tutan,

You can try loading the 16th calculated column in the edit script itself and then putting a 'where' clause with the 16th column < 20. This will limit the rows for the other 1 - 15 columns.

Or

if you want to limit rows in the straight table then you will have to write an if condition for all the 15 expressions something like:

if(Column16 < 20, Column1)

This will be quite tedious

Thanks

Manisha