Skip to main content

App Development

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

Announcements
JAN. 24, Q&A with Qlik: Making the Move to Qlik Cloud Reporting: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jlampard40
Contributor III
Contributor III

Reference lines on chart in % terms

Hi all - I have a chart which shows our KPI in % terms, as follows:

=Count([REPKPIData_EventKey])/ Count (TOTAL <REPKPIData_MonthReported> {<[REPKPIData_KPI]>} REPKPIData_EventKey)

There are multiple pathway fields which can be selected (REPKPIData_Pathway) and the data will change on the chart.  I need to show different reference lines on the chart, depending on what the user selects using the above pathway field.  So, if user selects '2WW' I need it to show a reference line at 90%.  If they select 'CT & MRI OP' I need it to show a reference line at 75%...and so on.

I've used the following formula, but it doesn't seem to work.  Any ideas?

If(GetCurrentField(REPKPIData_RepPathway) = '2WW', 90)

Many thanks all!

Labels (1)
2 Replies
jlampard40
Contributor III
Contributor III
Author

@vinieme12  - are you able to help with this at all?

vinieme12
Champion III
Champion III

 

Add another measure which will act as a trendline instead of adding Trendline to a measure

Try with Pick(Wildmatch(

 

=pick(wildmatch(REPKPIData_RepPathway,'2WW','CT & MRI OP')+1,DEFAULT%,0.9,0.75)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.