Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
jose_vargas
Creator
Creator

Chart line - expression dependent on a dimension?

Hi Community.

Let me explain my situation. I have a chart line, where I use 2 dimensión ( Time and Station) and a expression "sum(Quantity)". Its work great.

q10.jpg

But...  I need show a "GOAL" for each station.  For example if i Select "P1", need to show a line with the value "80 000" like a GOAL, the chart have to be like this.

q11.jpg

If I choose another Station, for example P3, i need to show other line whit the value "3000" like a GOAL

q12.jpg

How can I do that?  I try with reference line in presentation tab, but dont show anything

Thanks for your response

5 Replies
Chanty4u
MVP
MVP

maygoal.JPG be this?

sunny_talwar

Unmatched talent

Chanty4u
MVP
MVP

Haha  

jose_vargas
Creator
Creator
Author

I tried with that.... but not work.

I used that

=if(Estacion_04_Key=1, 450, if(Estacion_04_Key=2=250,100))

Chanty4u
MVP
MVP

is it working which you have tried?