Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Avarage line on combo chart

I also tried this on combo chart but failed.

prieper
Honored Contributor II

Avarage line on combo chart

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
Honored Contributor II

Avarage line on combo chart

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
Honored Contributor II

Re: Avarage line on combo chart

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

Avarage line on combo chart

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
Honored Contributor II

Re: Avarage line on combo chart

Here goes the attachment (advanced - huh? )

Peter

Not applicable

Re: Avarage line on combo chart

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

Re: Avarage line on combo chart

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

prieper
Honored Contributor II

Avarage line on combo chart

I don't get the missing point?

Peter

Community Browser