Discussion board where members can get started with QlikView.
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%?
Try this out. Go to presentation tab and remove tick from suppress zero value and enable zero on bar.
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)))
, LICENSE_GROUP) >=
, LICENSE_GROUP))- 10)
my dimension is simply,
do i need to modify my expression?
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.
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?
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.
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?