# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Partner

## restrict rows in straight table

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

1 Solution

Accepted Solutions
Partner
Author

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

18 Replies
MVP

Why don't you try dimension limit ?

Partner
Author

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

Creator

Hi!

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

Thanks.

Partner
Author

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

MVP

You can try with calculated dimension, expression something like:

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

Partner
Author

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

MVP

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

Specialist II

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

-Sundar

Creator

Hi

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!

Community Browser