Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Different Reference Lines based on Expression

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Different Reference Lines based on Expression

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.

View solution in original post

13 Replies
Highlighted
MVP
MVP

Re: Different Reference Lines based on Expression

Have a look at

How to get the used expression?

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

Highlighted
Not applicable

Re: Different Reference Lines based on Expression

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

My app is to complex for this workaround.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Different Reference Lines based on Expression

Hi,

Can you elaborate what complexity you have.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Not applicable

Re: Different Reference Lines based on Expression

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.

Highlighted
Partner
Partner

Re: Different Reference Lines based on Expression

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.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Different Reference Lines based on Expression

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Not applicable

Re: Different Reference Lines based on Expression

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.

Highlighted
Not applicable

Re: Different Reference Lines based on Expression

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.

Highlighted
Partner
Partner

Re: Different Reference Lines based on Expression

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?