Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to show max bar on bar chart?

I am trying to show only the max bar of my bar chart but I am struggling loads. I am using the expression:

sum( If(Program <> 'DETECT STOP', DowntimeDuration))

From this equation, I would need to display only the highest "DowntimeDuration" bar on the actual bar chart, how do I do this? I have tried things like max(sum( If(Program <> 'DETECT STOP', DowntimeDuration))) but that definitely does not work. I obviously have no idea what I am doing.

Program is the name of a list and DETECT STOP is just one variable that is excluded form that list and then the DowntimeDuration is the y-axis.

10 Replies
MK_QSL
MVP
MVP

Using Dimension Limit....

Even though selecting only largest few values the Expression Total in Expression tab will give you full total

while Using Rank & AGGR it will give you only the total of the items selected.

Though you can change it by selection SUM Of ROWS....!!!