topic Small problem with straight table in QlikView

Small problem with straight table

Fri, 14 May 2010 10:19:27 GMT

I ran into a problem with a straight table that I hope there is an easy fix for.

I got a table displaying % of sales for different companys. Now there are over 40 companys total but i only want to display nine of them and the rest as others. The problem is i dont get a %-number for the others tag. Is its possible to to display that information in a straight table? I know its possible in a pie-char atleast.

Example

Company A 13%

Company B 9%

Others 78% <---This number wont show

Small problem with straight table

Fri, 14 May 2010 10:30:05 GMT

Hi,

If i understood your question , below is the answer.

In pie char this can be achieved by limiting the lower limit area by 0.04.

Go to --> Presentation in pie chart and change the "Lower Limit on Slice Area" to 0.04

In Straight table this can be achieved by limiting the maxmum visibility.

Go to --> Presentation --> Max Number (1-100) to 9.

Check the attachment, Hope this will help you.

Small problem with straight table

Fri, 14 May 2010 10:40:33 GMT

I was able to slove my problem with this information.

Thx alot!