Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Total of barchart

Hello All,

Below is my bar chart:

This the expression I use : =SUM(QA1)/Count(QA1)

Can I show the total average in same bar chart?

Many Thanks,

Hasvine

1 Solution

Accepted Solutions

Re: Total of barchart

Check the attached:

Capture.PNG

6 Replies

Re: Total of barchart

Total Average of the three bars?

May be add a reference line with this expression:

Avg(TOTAL Aggr(SUM(QA1)/Count(QA1), DimensionNameHere))

Not applicable

Re: Total of barchart

Hi Sunny,

Does not work,

I need just 1 more bar to chow me the total average but it keeps on giving me a bar for each dimension.

Many Thanks,

Hasvine

Re: Total of barchart

I understand what you want, can you share raw data to show you how it can work

Not applicable

Re: Total of barchart

Hi Sunny,

Attached is the QVW.

It is frustrating :-D

Many Thanks,

Hasvine

Re: Total of barchart

Check the attached:

Capture.PNG

Not applicable

Re: Total of barchart

You are simply the best.. :-D

Many many Thanks,

Hasvine

Community Browser