topic Re: How to add a reference line in trend chart in QlikView

How to add a reference line in trend chart

abc_18 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In my application I have one trend chart with drill down capabilities, in this chart I need to show reference line for target value that is based on priority.

I have added reference line under presentation tab.

how to make that reference line visible only on third level of hierarchy that is priority value??

Hierarchy is like

Domain

Track

Priority

Please suggest..

Re: How to add a reference line in trend chart

vinieme12 — Tue, 29 Aug 2017 05:51:14 GMT

instead of Reference line add another expression with a condition

example

= if( GetFieldSelection('yourgrouphere') = 'Priority', Expression)

Re: How to add a reference line in trend chart

Anonymous — Tue, 29 Aug 2017 06:40:20 GMT

try this Expression as conditional show

=GetCurrentField(yourdrilldowngroup)='Priority'

Re: How to add a reference line in trend chart

abc_18 — Tue, 29 Aug 2017 07:01:30 GMT

where do I need to write this

presentation->reference line->edit->show conditional

I tried this , but still not working

Re: How to add a reference line in trend chart

abc_18 — Tue, 29 Aug 2017 07:03:58 GMT

Hi Vineeth,

Thanks for your response, I tried your expression but not getting desired output.

Target line is appearing for all the dimensions.

Re: How to add a reference line in trend chart

vinieme12 — Tue, 29 Aug 2017 07:05:33 GMT

Nope, not in presentation

you have to add another Expression

First > Enable conditional for the Expression

condition : = if( GetFieldSelection('yourgrouphere') = 'Priority', 1)

Expression = YOUREXPRESSION

Re: How to add a reference line in trend chart

Anonymous — Tue, 29 Aug 2017 07:09:51 GMT

I defined in Show conditional

if it doesnot work for you, put your Expression (60000 in example) in a TextBox

and check if the value fits to your Chart axes

Re: How to add a reference line in trend chart

abc_18 — Tue, 29 Aug 2017 07:26:00 GMT

Hi Vineeth,

I am using another formula for target line that is

Avg(SLA) in presentation tab->reference line and my expression is different.

I tried your expression under conditional tab

if( GetFieldSelections(oto drill) = Severity, 1).

but after writing this target line is not visible for any of the dimensions.

Re: How to add a reference line in trend chart

marcus_malinow — Tue, 29 Aug 2017 07:28:53 GMT

Your conditional display should be based on GetCurrentField(yourGroup)

For example:

if(GetCurrentField(yourGroup) = 'Priority', Expression)

Re: How to add a reference line in trend chart

vinieme12 — Tue, 29 Aug 2017 07:31:04 GMT

try below ,the function to use is GetcurrentField()

I hope Severity is the name of the Field!!

if( GETCURRENTFIELD('[oto drill]') = 'NAMEOFFIELD', 1).

Re: How to add a reference line in trend chart

vinieme12 — Tue, 29 Aug 2017 07:32:29 GMT

Not in Reference line , but define a NEW EXPRESSION as Conditional to check if the Priority field is in scope

Re: How to add a reference line in trend chart

abc_18 — Tue, 29 Aug 2017 07:51:09 GMT

Hi Guys,

Thanks all for your help, I might be missing something, I tried all expressions as suggested in my application,

but still not getting proper result.

I am attaching sample qvw file herewith, Please help me out.