Dimension Limits

[NareshGuntur]

I have a table

LOAD * INLINE [

    F1, F2, F3

    a1, 1, 6

    a2, 2, 5

    a3, 3, 4

    a4, 4, 3

    a5, 5, 2

    a6, 6, 1

];

and my chart gives me this

F1	sum(F2-F3)
	0
a1	-5
a2	-3
a3	-1
a4	1
a5	3
a6	5

and I wanted to get only negative values

F1	if(sum(F2-F3)<0,sum(F2-F3))
a1	-5
a2	-3
a3	-1

and I wanted to get the smallest 2, basically -5 and -3 and so I applied for Dimension Limits.

and I don't get any data

F1	if(sum(F2-F3)<0,sum(F2-F3))

Attached is the qvw.

[Anonymous]

which object you choosed for chart

i tried with a straight table and it works

[sunny_talwar]

May be try this expression:

=If(Rank(-1*If(Sum(F2-F3) < 0, Sum(F2-F3))) <= 2, If(Sum(F2-F3) < 0, Sum(F2-F3)))

[sunny_talwar]

I think he wants to see just lowest 2 values: -5 and -3

[NareshGuntur]

Thanks Sunny.

I want to understand if Dimension Limits is working as expected.

And I am worried to use this big expression as Sum(F2-F3) itself is a complex in my real scenario.

[Anonymous]

okay, i need to read until end

[sunny_talwar · Accepted solution]

I think the issue was related to the false statement in your if statement. We were leaving it as null, which was causing the issue. Try this expression:

=If(Sum(F2-F3) < 0, Sum(F2-F3), 0)

[Anonymous]

follow These instructions and you get what you want:

1) define a new Expression with sum(F2-F3) on first place

2) define Dimension Limits (resticht values... Show only smallest 2 values)

3) tab presentation: hide Expression (first one with sum(F2-F3)

here is what i get:

[NareshGuntur]

Thanks much.

I missed a silly thing

Cheers,

Naresh

[sunny_talwar]

I am glad we were able to resolve it quickly