topic bottom 10, 0 does not appear in QlikView

bottom 10, 0 does not appear

Mon, 04 Jul 2011 02:32:44 GMT

hi guys, i have a chart that shows the bottom 10 usage rate of a machine, calculated by activeTime/totalTime in %...

however those with 0 activeTime will result in a 0% usage rate, causing them to not appear on the chart...

so less than 10 bars will appear on the chart, the lowest bar showing is above 0%...

is it possible to make it appear, at least the machine name should show below the axis even if there's no bar since it's 0%?

bottom 10, 0 does not appear

deepakk — Mon, 04 Jul 2011 02:40:55 GMT

hi,

Try this out. Go to presentation tab and remove tick from suppress zero value and enable zero on bar.

Deepak

bottom 10, 0 does not appear

Mon, 04 Jul 2011 02:51:00 GMT

now all the bottom 10 shows, but additional bars that do not belong to the bottom 10 also appear...

this is my expression,

=(if(aggr(Rank(aggr(
sum(LIC_USED)
/sum(TOTAL_LIC)
, LICENSE_GROUP))
, LICENSE_GROUP) >=
(Max(total aggr(Rank(aggr(
sum(LIC_USED)
/sum(TOTAL_LIC)
, LICENSE_GROUP))
, LICENSE_GROUP))- 10)
, sum(LIC_USED)
/sum(TOTAL_LIC)))

my dimension is simply,

LICENSE_GROUP

do i need to modify my expression?

bottom 10, 0 does not appear

deepakk — Mon, 04 Jul 2011 03:16:48 GMT

hi,

Which chart type are you using ?. if it is bar or line then go to presentation max visible value add 10 and remove tick from show x axis scroll bar.

Deepak.

bottom 10, 0 does not appear

Mon, 04 Jul 2011 03:27:32 GMT

now it shows exactly 10 bars

however, the 10th bar does not belong to the bottom 10

so i guess it should be my expression that needs changes... any idea how?

bottom 10, 0 does not appear

deepakk — Mon, 04 Jul 2011 04:01:03 GMT

hi,

Go to sort tab use the expression part, addd your expression and say aseceding. This is one of the way to do it.

You can attach the application, if you are facing any issue.

bottom 10, 0 does not appear

Mon, 04 Jul 2011 04:21:07 GMT

i did search around n tried putting expression as a sort

however, values that are not even 0% appear too

this database has 3 tables

fieldA is one of the fields that links up these 3 tables

however, for some of the values on the chart that are not even 0%, their fieldA only appeared in 1 of the tables. that could be the reason why they do not even have a 0% bar

is there a way to ignore those rows?