topic Dimension limits problem in QlikView

Dimension limits problem

Fri, 05 Oct 2012 06:59:35 GMT

I am using two dimensions and one expression

I applied demension limit to show Largest 1 value. It is sorted on the bases of first expression(hours)

But it is showing result like this

Dim1 Dim2 Hours

3526 july 4000

3526 Aug 240

3526 Jun 16

But result should only show the first row. How it is possible?

thanks

Re: Dimension limits problem

Fri, 05 Oct 2012 07:07:28 GMT

Hi Harleen,

You have to set the dimension limits on both the dimensions ( Dim1 and Dim 2)

Regards

Satheesh

Re: Dimension limits problem

Fri, 05 Oct 2012 07:14:29 GMT

Satheesh,

i have applied that. But again when i increase dimension limit to "largest 3".

It is showing 9 rows

but i noticed it is showing 3 unique Dim1 repeatedly

Resource No	Month Year	Hours
		1727628
3526	Jul-2012	40080
3554	Sep-2012	24883
3468	Aug-2012	19826
3468	Sep-2012	12773
3554	Jun-2012	504
3554	Mar-2012	494
3468	Apr-2012	253
3526	Aug-2012	240
3526	Jun-2012	16

Thanks

Re: Dimension limits problem

Fri, 05 Oct 2012 07:25:14 GMT

Hi Harleen,

Set the dim 1 limit to largest 3 and the dim2 limit to largest 1

Regards

Satheesh

Re: Dimension limits problem

Fri, 05 Oct 2012 07:36:29 GMT

yeah satheesh,

it worked but i don't care about the restrictions based on dimensions. What i have read about dimension limits is that it should always show top N values based on first expression not on the bases of Dimensions.

so that whole straight table should show largest values based on Expression

thanks