Qlik Community

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 
Search instead for 
Did you mean: 
raghavsurya
Partner
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
raghavsurya
Partner
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

View solution in original post

18 Replies
tresesco
MVP
MVP

Why don't you try dimension limit ?

raghavsurya
Partner
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

marchoctober
Creator
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.

raghavsurya
Partner
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

tresesco
MVP
MVP

You can try with calculated dimension, expression something like:

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

raghavsurya
Partner
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

tresesco
MVP
MVP

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

sundarakumar
Specialist II
Specialist II

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

-Sundar

marchoctober
Creator
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!