topic Re: Dimension Limits in QlikView

Dimension Limits

NareshGuntur — Tue, 02 Feb 2016 15:22:12 GMT

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.

Re: Dimension Limits

Anonymous — Tue, 02 Feb 2016 15:26:28 GMT

which object you choosed for chart

i tried with a straight table and it works

Re: Dimension Limits

sunny_talwar — Tue, 02 Feb 2016 15:26:29 GMT

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)))

Re: Dimension Limits

sunny_talwar — Tue, 02 Feb 2016 15:27:36 GMT

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

Re: Dimension Limits

NareshGuntur — Tue, 02 Feb 2016 15:32:51 GMT

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.

Re: Dimension Limits

Anonymous — Tue, 02 Feb 2016 15:33:56 GMT

okay, i need to read until end

Re: Dimension Limits

sunny_talwar — Tue, 02 Feb 2016 15:38:11 GMT

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)

Re: Dimension Limits

Anonymous — Tue, 02 Feb 2016 15:39:41 GMT

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:

Re: Dimension Limits

NareshGuntur — Tue, 02 Feb 2016 15:44:12 GMT

Thanks much.

I missed a silly thing

Cheers,

Naresh

Re: Dimension Limits

sunny_talwar — Tue, 02 Feb 2016 15:48:17 GMT

I am glad we were able to resolve it quickly