topic Re: Re: Re: Dynamic Reference Line Chart in QlikView

Dynamic Reference Line Chart

Mon, 10 Feb 2014 05:04:21 GMT

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.

Re: Dynamic Reference Line Chart

jonathandienst — Mon, 10 Feb 2014 06:46:55 GMT

Use something like this for the reference line expression:

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

HTH

Jonathan

Re: Dynamic Reference Line Chart

jonathandienst — Mon, 10 Feb 2014 07:09:35 GMT

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

Re: Re: Dynamic Reference Line Chart

Mon, 10 Feb 2014 07:28:15 GMT

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.

Re: Dynamic Reference Line Chart

jonathandienst — Mon, 10 Feb 2014 07:47:18 GMT

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

Re: Dynamic Reference Line Chart

oleg_orlov — Mon, 10 Feb 2014 07:54:16 GMT

Hi!

How to get the used expression?

Hope this helps,

Oleg

Re: Re: Re: Dynamic Reference Line Chart

jonathandienst — Mon, 10 Feb 2014 08:24:38 GMT

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

HTH

Jonathan

Re: Re: Dynamic Reference Line Chart

Mon, 10 Feb 2014 09:01:24 GMT

Thanks a lot Jonathan for your effort.

Regards,

Zain

Re: Re: Dynamic Reference Line Chart

Mon, 10 Feb 2014 09:02:39 GMT

Oleg, Thank for the information.

Regards,

Zain.

Re: Re: Re: Dynamic Reference Line Chart

qlikpahadi07 — Mon, 10 Feb 2014 09:17:08 GMT

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

Re: Re: Dynamic Reference Line Chart

Mon, 10 Feb 2014 11:07:09 GMT

Thanks Dear to share application, i also did as same u did, and you are right Jonathan give a good solution to do the same work.

Regards,

Zain.