Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Average and total in sane bar graphic

Hi,

How I can show this totals numbers and average of Out time and On time on bar graphic?

Dimension: Year / Month

From this expression,

=Num(Count({<state={'Closed'}, OnTime={1}>} Ticket),'#.##0')

=Num(Count({<state={'Closed'}, OnTime={0}>} Ticket),'#.##0')

graphic.png

Is possible?
Regards,

6 Replies
d_pranskus
Contributor III

Re: Average and total in sane bar graphic

Hi

You can use Text in Chart Area on the Presentation tab of chart properties.

Cheers

Darius

Not applicable

Re: Average and total in sane bar graphic

Sorry, but how I can? I don't have experience with this…


d_pranskus
Contributor III

Re: Average and total in sane bar graphic

Do you want it by months or just total value?

Not applicable

Re: Average and total in sane bar graphic

I want the totals by month and, which is the average per each expression of this total.

For example for Jan, I would do something like this:

graphic.png

d_pranskus
Contributor III

Re: Average and total in sane bar graphic

This is not possible as far as I know with simple bar chart

Not applicable

Re: Average and total in sane bar graphic

ok thanks, and there are another similar option?

Community Browser