topic Re: Different Reference Lines based on Expression in QlikView

Different Reference Lines based on Expression

Fri, 04 Mar 2016 14:28:46 GMT

First post in the community
I have a difficult question.

I'm making a chart that shows Volumes, Hours and Productivity for a certain Process. These expressions are grouped in one chart via Cyclic group. They all have different Targets and I want to show these Targets via a horizontal line, but when I add a expression for the Target, it will show the line in all the different cyclic expressions. I also tried it in the reference line option but I cant figure it out.

Is there a solution that i can show a target line based on the expression the user is seeing?

Please help,

Jasper

Re: Different Reference Lines based on Expression

swuehl — Fri, 04 Mar 2016 19:26:23 GMT

Have a look at

How to get the used expression?

I reused JohnW's sample and added an example for a dynamic reference line.

Re: Different Reference Lines based on Expression

Mon, 07 Mar 2016 07:44:52 GMT

Smart solution, but this is not quite what I am looking for.

My app is to complex for this workaround.

Re: Different Reference Lines based on Expression

kaushiknsolanki — Mon, 07 Mar 2016 08:03:54 GMT

Hi,

Can you elaborate what complexity you have.

Regards,

Kaushik Solanki

Re: Different Reference Lines based on Expression

Mon, 07 Mar 2016 08:34:49 GMT

I have 20 Graphs that all show three things: Productivity(Bars), Hours(Line) and Volume(Bars). These graphs represent the results on different level in the company. For instance, you have a productivity on Site level and you have a productivity on different clients within the Site. These graphs are filled based on the selection of the user through variables who keeps the selection history of the user. For instance if I select a certain Site, I see the performance of the site and its Clients, but if I select a different Site, I see that Site with its corresponding Clients in the same graphs.

Now I want to show a target line in these graphs that correspond to the selection and the graph that is showing.

Re: Different Reference Lines based on Expression

-SW- — Mon, 07 Mar 2016 08:49:00 GMT

Hi Jasper,

Apologies if I understood your question wrong. From what I gathered you want to use a cyclic group, and each of those have their own set targets (for each Volumes, Hours and Productivity).

In this case, you should add all 3 targets as expressions to the graph, each as their own line.

and then tick to activate the conditional (within expressions tab at the top right) and set the following for each expression

=if(GetCurrentField(Selections) ='Volumes', 1,0)

=if(GetCurrentField(Selections) ='Hours', 1,0)

=if(GetCurrentField(Selections) ='Productivity', 1,0)

And this should mean the right one will only show if the cyclic one is showing the correct string. Please note this will only work if the cyclic group is the first dimension.

Re: Different Reference Lines based on Expression

kaushiknsolanki — Mon, 07 Mar 2016 10:59:30 GMT

You Can do one thing you can create a variable which will store the values of the limit and depending on selection you can change the value of variable, which will change the reference line of chart.

Regards,

Kaushik Solanki

Re: Different Reference Lines based on Expression

Mon, 07 Mar 2016 12:39:22 GMT

Sorry doesn't work.

I don't select the name Volumes or Hours or Productivity anywhere.

I select the name of the Site and then I get the graph wich shows me the productivity of that site. Then I can switch between Productivity, Volume and Hours by presseing the cyclic button in the chart. So I never select the names Productivity, Volumes or Hours in a Field.

Basicly what I am looking for is a method like getlabelname() of the chart, but this function doesn't exists. So im looking for a smart and easy workaround.

Re: Different Reference Lines based on Expression

Mon, 07 Mar 2016 12:44:14 GMT

This works if you have to select a value to change the graph, but that's not the case. In the dashboard you select a Site in a field and you get a productivity graph back. Then you can press the cyclic button in the graph and it changes to Volumes or Hours. So you never select the value Productivity, Volumes or Hours in a field. That means you can't depend a value of a variable to a selection, at least I can't.

What im looking for is something like =GetCurrentLabelName(CH01), but this function doesn't exists.

Re: Different Reference Lines based on Expression

-SW- — Mon, 07 Mar 2016 13:03:29 GMT

I use that in a cyclic button in the chart and it works for me.

The GetCurrentField grabs it from your dimension.

If you want, you can upload a test document and I can show you how it may work?

Re: Different Reference Lines based on Expression

swuehl — Mon, 07 Mar 2016 16:41:20 GMT

Jasper,

I don't know any method to retrieve the current expression from an expression group.

Maybe you can work around using conditional expressions instead of an expression group. See attached sample.

Re: Different Reference Lines based on Expression

Tue, 08 Mar 2016 09:36:36 GMT

Great!!!

I've looked at your example file and the second solution with the inputbox works for me.

One small question though.

How do i remove the dots in the inputbox?

Re: Different Reference Lines based on Expression

swuehl — Tue, 08 Mar 2016 10:36:11 GMT

Have you cleared the 'Label' for the variable in general tab of the input box?

Re: Different Reference Lines based on Expression

Tue, 08 Mar 2016 10:38:55 GMT

Nope

Thnx got it.