Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

mini bar chart not showing

Hi All,

I am using following expression for creating a mini bar chart in the table for my duration field which is in the format hh:mm:ss

repeat('█',

rangemax(rangemin( sum(duration_field), 10),0)

)

 

but I getting sum as 0, due to which the bar is not appearing.

kindly help.

4 Replies
Highlighted

Did you check to make sure that Sum(duration_field) is a number between 0 and 10?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor III
Contributor III

Under text object i took sum(duration_field) and change its format to number, and I am getting sum as 14. and in duration format sum is coming as 340:32:33 in text object , but when I am using sum function along with rangemax and min in the table, there under TOTALS the sum is coming as 0, because of which graph are not appearing .

i have a table with 2 field as

duration_field       duration with bar(function used here as shown above)

total 340:32:33      total 0

00:00:00

00:00:18                    -

and so on....

 

against 00:00:18, i need to represent this particular time  in the form of mini graph

 

Highlighted

You should get a repeat of 10. Your syntax looks OK. Try the expression

=rangemax(rangemin( sum(duration_field), 10),0)

in the table in question.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Contributor III
Contributor III

I applied this function , with this I am getting the sum, but if I am applying repeat function along with this in order to show the graph, I am not getting the display of graph and under totals in table sum is coming as 0