How to apply row restriction in straight table

[vipingarg23]

Hi Team,

How to limit number of rows in Straight table?

I am using Dimension limit and Max rows (In Presentation tab) but both are not working.

[sunny_talwar]

May be you can try with RowNo(). For example if you want to only see first 10 rows, you can do this If(RowNo(TOTAL) < 11, your expression)... Notice that this will show top 10 in the order you already have in your chart

[avkeep01]

Is the object attached? Does the caption text shows "<Name> (Detached)"?

[vipingarg23]

Thanks Sunny,

I knew this but I have lot of expressions So I have to apply the same in each expression. Don't we have any direct method in Qlikview So that I can apply the same for all.?

[sunny_talwar]

Direct method is Dimension limits or calculated dimension, but without more details, I won't know what to do

[vipingarg23]

Yes..It is attached.

[vipingarg23]

I am creating Adhoc report. In which, I want that user can see only 40000 rows, not more than that.

[avkeep01]

It is not the perfect solution but I sometimes forces the users making more selections to reduce the amount of rows by using the calculation condition on the General sheet in the straight table. If the amount of rows is higher then 400.000 then the message: "Make more selections to reduce the amount of rows "  is shown.

[sunny_talwar]

How many expressions do you have?

[vipingarg23]

Around 45 expressions