Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

bottom 10, 0 does not appear

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%?

6 Replies
deepakk
Not applicable

bottom 10, 0 does not appear

hi,

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

Deepak

Not applicable

bottom 10, 0 does not appear

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?

deepakk
Not applicable

bottom 10, 0 does not appear

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.

Not applicable

bottom 10, 0 does not appear

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?

deepakk
Not applicable

bottom 10, 0 does not appear

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.

Not applicable

bottom 10, 0 does not appear

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?