Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Specialist III
Partner - Specialist III

hi,

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

Deepak

Not applicable
Author

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
Partner - Specialist III
Partner - Specialist III

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
Author

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
Partner - Specialist III
Partner - Specialist III

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
Author

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?