Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tanjavarwijk
Contributor III
Contributor III

Dimension limit does not work

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

I tried to use the dimension limit

Screen.jpgdimension.jpg

8 Replies
sibin_jacob
Creator III
Creator III

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
Contributor III
Contributor III
Author

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
Not applicable

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

the Dimension Limit is baes on the first Expression!

what is your first Expression?

tanjavarwijk
Contributor III
Contributor III
Author

The expression is :

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

Anonymous
Not applicable

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

tanjavarwijk
Contributor III
Contributor III
Author

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

Anonymous
Not applicable

strange behavior, can you share your qvw?

Anonymous
Not applicable

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