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: 
Heny
Contributor II
Contributor II

Static reference line

Hi,

i need help with static reference line on a scatter plot.

my chart shows clients as my dimension (bubble), and the Y axis has a measure for number of transactions.

i added 2 reference lines that show me the clients that are above the top line, between the 2 lines or below the bottom line, meaning the number of transactions they have gives me an indication of the client's size.

the thing is that the reference line changes according to my selection of clients, and i need it to stay static. How to do it?

i used this simple expression for my lines:

ref line 1: =sum(NumOfTransactions)/20

ref line 2: =sum(NumOfTransactions)/100

Thanks!

Heny

 

1 Solution

Accepted Solutions
saminea_ANZ
Creator
Creator

May be

ref line 1: =sum({1}NumOfTransactions)/20

ref line 2: =sum({1}NumOfTransactions)/100

View solution in original post

1 Reply
saminea_ANZ
Creator
Creator

May be

ref line 1: =sum({1}NumOfTransactions)/20

ref line 2: =sum({1}NumOfTransactions)/100

View solution in original post