Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
jayati_shrivast
Contributor III
Contributor III

Mini Bar Chart not displaying properly in table

Hi All,

I have a table in which I have a field as duration_mc which is in the format hh:mm:ss.

I need to represent this time in the form of mini bar against each value of time.

currently I am getting same bar for all the time values, the length of the bar is not increasing as per the value of time.

Below is the snapshot attached.

miniBar.png

here as we can see the bar length for o seconds as well as 18 seconds is same, which needs to be different.

What changes i should apply to the  expression in order to achieve this.

Kindly help.

Thanks

3 Replies
JordyWegman
Partner
Partner

Hi Jayati,

Try this:

Repeat('▮',round(sum(duration_mc)/max(total sum(duraction_mc)))*10)

Jordy

Climber

Work smarter, not harder
jayati_shrivast
Contributor III
Contributor III
Author

Hi, I tried this expression , but I am not getting any bar chart ,it is coming as null.

Below is the snapshot

 barMini2.png

 

JordyWegman
Partner
Partner

I forgot the aggr(). Use this one:

Repeat('▮',round(sum(duration_mc)/max(total aggr(sum(duration_mc),duration_mc))*10))

Jordy

Climber 

Work smarter, not harder