Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fixed reference line in chart - is it possible?

Hello everyone!

I have a chart from sum of a specific col.A and a reference line with avg(col.A) as value. This reference line changes along with the whole chart when selections are made in the filters and tables in the sheet.

Is it possible to have a reference line that always shows the average value of col.A regardless of the selections in the tables? If yes, please show me how.

Thanks in advance!

1 Solution

Accepted Solutions
undergrinder
Specialist II
Specialist II

Hi Trinh,

Try the following function:

avg({1} col.A)

In set analysis the following formula reset all dimension: {1}

Hope this helps.

G.

View solution in original post

3 Replies
undergrinder
Specialist II
Specialist II

Hi Trinh,

Try the following function:

avg({1} col.A)

In set analysis the following formula reset all dimension: {1}

Hope this helps.

G.

View solution in original post

brunobertels
Specialist II
Specialist II

Hi

Use set analysis calculation for your reference line and put 1 rather than $ to ensure to keep the mesure even if you made selection :

may be this :

Count({1}col.A)

Hope it helps

Bruno

reddy-s
Master II
Master II

Hi Trinh,

Yes its absolutely possible. Under the add-ons section create a reference line and add this expression:

avg({1}Col)