Measure independent of dimension

[#1]

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.

[#2 · Accepted solution]

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

[#3]

Figured it out soon after I posted it. Thanks.