Dimension limit does not work

[tanjavarwijk]

In the table I only want to see de rows above the red line.

I tried to use the dimension limit

[sibin_jacob]

If you want to limit the first 10 records, you need to use the first option.

'Allen Weergeven'

The option is "Show only" then select "first" then give the number 10

If you are choosing this option, you need to sort the table properly, it will show only First records.

[tanjavarwijk]

It must be a calculated dimension, because the accumulation of column 4 /5 is important. Not only 10 rows, (in this example there are 11)

[Anonymous]

what is a calculated Dimension? if column(5) > 0, ...???

the Dimension Limit is baes on the first Expression!

what is your first Expression?

[tanjavarwijk]

The expression is :

if(Column(5)>0,Column(2),(Column(5)+Column(2)))

[Anonymous]

Change the Dimension Limit and use ReferenceID instead of ItemNumName for the Dimension limit

[tanjavarwijk]

I have tried all kinds of settings, also that one.

[Anonymous]

strange behavior, can you share your qvw?

[Anonymous]

I did  some test on an similiar app. obviously Expression column(x) + column(y) doesnot work

I experiended the same behaviour, that Dimension Limit doesnot work

After copying the Expression from column(x) and column(y) to first Expression it worked in my case

first expression

if (Expression of column(5)>0, Expression of column(2), Expression of column(2)+Expression of column(5)

Maybe there is another solution, that's what i figured out