topic Re: Chart line - expression dependent on a dimension? in QlikView

Chart line - expression dependent on a dimension?

jose_vargas — Thu, 22 Mar 2018 17:53:37 GMT

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.

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.

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

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

Thanks for your response

Re: Chart line - expression dependent on a dimension?

Chanty4u — Thu, 22 Mar 2018 18:03:18 GMT

may be this?

Re: Chart line - expression dependent on a dimension?

sunny_talwar — Thu, 22 Mar 2018 18:06:05 GMT

Unmatched talent

Re: Chart line - expression dependent on a dimension?

Chanty4u — Thu, 22 Mar 2018 18:08:58 GMT

Haha

Re: Chart line - expression dependent on a dimension?

jose_vargas — Thu, 22 Mar 2018 19:49:07 GMT

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

I used that

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

Re: Chart line - expression dependent on a dimension?

Chanty4u — Fri, 23 Mar 2018 07:32:38 GMT

is it working which you have tried?