Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

3 Replies
cesaraccardi
Valued Contributor

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

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

Not applicable

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

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
Contributor

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

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

Community Browser