topic Expression as dimesion in QlikView

Expression as dimesion

Wed, 15 Sep 2010 07:12:39 GMT

i want to sort a table using different expression which is based on some other column.

Now i want to limit the Dimension. But it is not possible in Line Chart.

So i tried to put if(rank(expression)<11, Dimension)

But the problem is expression is always calculated over dimension. So the above thing returning Null value when used as Dimension. If i used the same in Expression as if(rank(expression)<11, Dimension) over the Dimension it is returning the correct top values.

Anything can be done to get the Top dimension using Expression without placing it over a dimension?

I explained my problem as simple as i can.

Any ideas ???

Expression as dimesion

vgutkovsky — Wed, 15 Sep 2010 07:15:06 GMT

You need to use the expression within an aggr()--the dimension of the aggr would be the dimensions you want to recreate.

Regards,

Expression as dimesion

Wed, 15 Sep 2010 07:20:38 GMT

Hi,

It is possible to limit the Dimension in Line Chart.

In Line Chart-Properties-Presentation-Dimension Limitations(Right Top)-Max Visible Number.

Select this number as 10 or whatever you want (<100).

Sort your data based on Expression in Sort options.

Hope it resolves your problem.

Happy Thoughts

Expression as dimesion

Wed, 15 Sep 2010 07:22:09 GMT

nope...aggr() is not working there for me...thats why i raised this question.

Expression as dimesion

vgutkovsky — Wed, 15 Sep 2010 07:29:33 GMT

Try this: aggr(if(rank(total expression)<11, Dimension),Dimension). If that doesn't work, please post an example app.

Expression as dimesion

Wed, 15 Sep 2010 07:47:19 GMT

But i want Others label which is not possible in Line chart.

Expression as dimesion

vgutkovsky — Wed, 15 Sep 2010 07:57:22 GMT

aggr(if(rank(total expression)<11, Dimension,'Other'),Dimension)

Expression as dimesion

Wed, 15 Sep 2010 08:07:53 GMT

Thanks its working great. But placing 'Others' in else part of if, is not working..I want to sum all other dimensions under the label of 'Others'. Any Idea...

Expression as dimesion

vgutkovsky — Wed, 15 Sep 2010 08:08:54 GMT

It should work. Please post an example of your application.

Expression as dimesion

Wed, 15 Sep 2010 08:20:21 GMT

Hi,

Its working fine now..I added the 'Other' inside the aggr, and also aggr the sorting expression.

Thanks a lot

Expression as dimesion

Wed, 21 Mar 2012 22:03:58 GMT

Would you mind posting your solution? I have a simular problem that i can't seem to make work.

Here is my expression

=aggr(if(rank(Total sum(CaseCnt)) < 4,HospitalShortName,'Other'),HospitalShortName)

I am using a line chart so i want the top 4 Hospital names and the remainder in an "Others" Catagory.