Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avarage line on combo chart

Hello all

i'm new with charts.

I have bar chart. In dimention months field inserted. in expression count something.

And i want to show avarage line of months. I checked trendline avarage but it's now showing right.

Any suggestion pls.

regards

11 Replies
Not applicable
Author

I also tried this on combo chart but failed.

prieper
Master II
Master II

Might be a versioning Problem - which version are you running?

Just tried with 10SR2 and works without a problem.

Does someone knows, how to upload a sample-file?

HTH
Peter

IAMDV
Luminary Alumni
Luminary Alumni

Please can you post the QV document with some sample data?

I checked trendline avarage but it's now showing right (Please can you explain this...)

Thanks - DV

IAMDV
Luminary Alumni
Luminary Alumni

Peter - Please click on Use advanced editor (top right on reply window). Then you will see Attach Files Option on bottom left.

Cheers - DV

Not applicable
Author

in replay to proper there is use advanced editor on top right side.

ok. my expression is

count({$<month_field = {">-1<16"}>} distinct id_field)

this month_field calculated from 2 date. And it's contains some negative numbers also hight month numbers. maybe that's why trendline avarage not showing right.

prieper
Master II
Master II

Here goes the attachment (advanced - huh? )

Peter

Not applicable
Author

Thanks Peter for some charts.

I realized that trendline avarage will not solve my problem. It will show only count(value) avarage right?

I don't want avarage of some counted values i want avarage of the month. If is it possible to show.

Muncho

Not applicable
Author

I mean is it possible to show avarage line of dimention. In my case it's month numbers. Not avarage line of expression.

prieper
Master II
Master II

I don't get the missing point?

Peter