Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Measure independent of dimension

Hello All,

I am using Qlik Sense, Can you suggest as to how I can write a measure which is just independent of one measure. I have attached a sample snip which shows that my average of the KPI is 10.93k. I want this to show up as a goal line in the graph below. Help me achieve that please.

Thanks in advance.

Capture.PNG

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Measure independent of dimension

Hi Siddharth,

In Graph Properties --> Add-ons tab, there is an option for Reference Line.

In the expression of the reference line, add expression as Avg(KPI).

This will bring up a reference line (goal line in your case) in the graph.

Hope this is what you are looking for.

Regards,

Rohan

View solution in original post

2 Replies
Highlighted
Not applicable

Re: Measure independent of dimension

Hi Siddharth,

In Graph Properties --> Add-ons tab, there is an option for Reference Line.

In the expression of the reference line, add expression as Avg(KPI).

This will bring up a reference line (goal line in your case) in the graph.

Hope this is what you are looking for.

Regards,

Rohan

View solution in original post

Highlighted
Not applicable

Re: Measure independent of dimension

Figured it out soon after I posted it. Thanks.