Discussion board where members can get started with QlikView.
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.
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.
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.
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.
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