topic Re: Dimension limit does not work in QlikView

Dimension limit does not work

tanjavarwijk — Wed, 08 Aug 2018 07:23:11 GMT

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

I tried to use the dimension limit

sibin_jacob — Wed, 08 Aug 2018 08:07:41 GMT

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 — Wed, 08 Aug 2018 08:15:21 GMT

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 — Wed, 08 Aug 2018 08:41:46 GMT

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

the Dimension Limit is baes on the first Expression!

what is your first Expression?

tanjavarwijk — Wed, 08 Aug 2018 08:43:57 GMT

The expression is :

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

Anonymous — Wed, 08 Aug 2018 08:56:20 GMT

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

tanjavarwijk — Wed, 08 Aug 2018 09:12:22 GMT

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

Anonymous — Wed, 08 Aug 2018 09:16:10 GMT

strange behavior, can you share your qvw?

Anonymous — Wed, 08 Aug 2018 09:24:34 GMT

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