Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?