topic Re: restrict rows in straight table in QlikView

restrict rows in straight table

raghavsurya — Sun, 23 Feb 2014 06:33:15 GMT

Hi,

I want to restrict the number of rows based to 3 on EBITDA values. I am using this expression to get EBITDA value

Sum({<FY={$(=Max(FY))},GPLParticulars={'EBITDA'},DateID={$(=Max(DateID))}>}PLActual)

can somebody suggest how I can do it.

Regards,

Raghav

Re: restrict rows in straight table

tresB — Sun, 23 Feb 2014 06:35:51 GMT

Why don't you try dimension limit ?

Re: restrict rows in straight table

raghavsurya — Sun, 23 Feb 2014 06:46:14 GMT

Hi,

The dependency to restrict the rows is based on expression value. I am not able to do in dimension limit. Please let me know if any work around is there.

Regards,

Raghav

Re: restrict rows in straight table

marchoctober — Sun, 23 Feb 2014 07:06:49 GMT

Hi!

Your question is a little bit fuzzy. Could you please provide us with detail explanation what you want and what you have?

Thanks.

Re: restrict rows in straight table

raghavsurya — Sun, 23 Feb 2014 07:09:50 GMT

Hi,

I have to show top performing cities based on Net Profits. I have one dimension which is city and 4 other expressions showing Revenue, Cost, Gross Profit and Net Profit. The customer wants to see only top 3 performing cities based on net profit in a straight table chart.

Regards,

Raghav

Re: restrict rows in straight table

tresB — Sun, 23 Feb 2014 07:14:33 GMT

You can try with calculated dimension, expression something like:

=Aggr( if(Rank(Sum([Net Profit]))<4, City), City)

Re: restrict rows in straight table

raghavsurya — Sun, 23 Feb 2014 07:33:27 GMT

Hi,

I used the Aggr function suggested by you, I am getting a blank row totalling for rest of the cities other than top 3. the customer do not want this blank row. Is there a way to avoid this.

Regards,

Raghav

Re: restrict rows in straight table

tresB — Sun, 23 Feb 2014 07:35:42 GMT

In the dimension tab-> tick on , "Supress When Value is Null"

Re: restrict rows in straight table

sundarakumar — Sun, 23 Feb 2014 07:37:17 GMT

You have to select suppress when value is null in the dimension tab selecting the calculated dimension

-Sundar

Re: restrict rows in straight table

marchoctober — Sun, 23 Feb 2014 07:41:43 GMT

See the attach.

Dimention limit to 3, and further in straight table I sort to required expr., asc or desc.

Note, that if you use expr that is a result of calcualtion based on the values of other expr, f.e. sum(Gross-Cost) so it is ok, but if you will use the construction with Cloumn(1)-Column(2) sorting by double clicking the expr in straigh table will not working.

I hope it will help!

Re: restrict rows in straight table

raghavsurya — Sun, 23 Feb 2014 07:47:19 GMT

hi,

Can you suggest if there is a way to populate the bottom 3 cities as well in a straight table and any option to show top and bottom 3 by click of a button.

Regards,

Raghav

Re: restrict rows in straight table

raghavsurya — Sun, 23 Feb 2014 07:58:34 GMT

hi,

thanks for your file. Is there a way to change the sort order from descending to ascending by click of a button.

Regards,

Raghav

Re: Re: restrict rows in straight table

tresB — Sun, 23 Feb 2014 09:06:08 GMT

Yes, put a negative sign, before sum(). And mark the 'correct answer' correctly the correct one please.

Re: restrict rows in straight table

marchoctober — Sun, 23 Feb 2014 10:34:14 GMT

Yes. Double click on the appropriate expresion. And user can freely also move the expressions.

Re: restrict rows in straight table

marchoctober — Sun, 23 Feb 2014 10:39:48 GMT

As for a button, it is makes no sense as it by default integrated in straight table. It could take lots of time to do that by button to you.

Re: restrict rows in straight table

marchoctober — Sun, 23 Feb 2014 10:48:47 GMT

Do you need only a button?

Re: restrict rows in straight table

raghavsurya — Mon, 24 Feb 2014 12:30:25 GMT

Thanks a lot for your valuable suggestion

Re: restrict rows in straight table

Mon, 24 Feb 2014 12:32:42 GMT

Supress When Value is Null"

Re: restrict rows in straight table

Anonymous — Mon, 24 Feb 2014 12:56:53 GMT

Hi Raghvendra,

You can easily show the top and below amount according to the dimension in straight table bcz in straight table the Dimension limit Tab is available .The problem is occuring when we use the pivot table then in that case we use the aggr() function or calculated dimension..