topic Straight table in QlikView

Straight table

Thu, 02 Sep 2010 15:18:50 GMT

Hi everybody,

i have created a straight table showing the revenue for all products. Because of the table size i just want to show the top 10 products. My problem is, that the total i can choose in the properties shows the total of all products, but i just want to sum up the top 10.

Does anyone know the answer.

Appreciate any help in this regard.

Thanks and Regards

Philipp

Straight table

Thu, 02 Sep 2010 15:24:33 GMT

Always i have a same problem...

I do a trick.....lololol......a calculated a total of top 10 on the text object and fixed it on the total of straight table.....

if anyone have another solution..... i appreciate too

Straight table

Thu, 02 Sep 2010 18:39:53 GMT

Could you explain your problem again?

Sorry I didn't get it.

ERP Consulting

SAP ERP Consultants

Straight table

Fri, 03 Sep 2010 07:33:29 GMT

Hi, the following is an example for my problem. First example are the complete products with their revenue.

Product	Revenue
A	50
B	40
C	30
D	20
E	10
Total	150

Now i just want to show the top 3 ans the sum just for this 3 products (green). The only thing i reached so far is the red, which is the total of all products again.

Top 3
A	50
B	40
C	30
Total (for Top 3)	120
Total	150

Thanks

Philipp

Straight table

johnw — Sat, 04 Sep 2010 00:45:01 GMT

dimension = Product
expression = if(rank(sum(Revenue))<=3,sum(Revenue))
total mode = sum of rows
max number = 3

Straight table

sunil2288 — Sat, 04 Sep 2010 09:17:10 GMT

HI Philip

You can use the Pareto select option by creating a button.

What you supposed to do is ..

Create a button named TOP 30 then in the properties of button add action as select--> Pareto select

here set Field as Product and expression as sum(revenue) then set the percentage you want to view let it be 30...

Hope it will solve your problem...

Re: Straight table

Thu, 24 Oct 2013 05:39:54 GMT

This is simple..

First check the "Restrict values to" option in the Dimensional Limit tab from the Properties of the straight table.

now select largest 10 values and uncheck show Others.

Now in the expressions tab, in the right hand side part, in total mode select sum of rows.

I hope this will solve your problem