Dynamic Reference Line Chart

[#1]

Dear,

i have define 5 expressions as a Group (cyclic) and two dimensions in chart, and its working fine, now i am going to define Reference line based on expression for example is given below:

exp1 is Gross login & reference line for Gross Login is 20

exp2 is Return & reference line for Return is 25

exp3 is Net login & reference line for Net Login is 30. and so on.

Problem is how i can define the reference line expression based on above expression, means if i select Gross login expression then reference line move on 20 or if i select Return expression then reference line move on 25 and so on.

Kindly guide me how i can define this.

Regards,

Zain.

[jonathandienst]

Hi

Use something like this for the reference line expression:

=Pick(Match(GetCurrentField(Group), 'Gross login', 'Return', 'Net login'), 20, 25,30)

HTH

Jonathan

[jonathandienst]

You might get a syntax warning (squiggly underlines) under the group name - just ignore these

[#4]

Dear thanks for the reply, I tried but its didnt show me reference line and kindly remember i grouped all expression and expression group havnt assign name,

i also attached the application.

Regards,

Zain.

[jonathandienst]

Hi

You are not using a cyclic group - you are using an expression group. I don't know any way to identify which expression is selected in an expression group.

HTH

Jonathan

[oleg_orlov]

Hi!

How to get the used expression?

Hope this helps,

Oleg

[jonathandienst · Accepted solution]

Hi

I have implemented the cycling using a variable instead. Updated qvw attached.

HTH

Jonathan

[#8]

Thanks a lot Jonathan for your effort.

Regards,

Zain

[#9]

Oleg, Thank for the information.

Regards,

Zain.

[qlikpahadi07]

Hi Shiekh,

First thanks Oleg for sharing the link I really appropriate.

Also it seems Jonathan have given the solution which seems perfect.... for a record I have implemented the same and find the attachment

Cheers to all

Learned new think today

Thanks