Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
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

2 Replies
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

Not applicable

Re: Measure independent of dimension

Figured it out soon after I posted it. Thanks.