topic Re: Dynamic label expression as column name in line chart in QlikView

Dynamic label expression as column name in line chart

Wed, 25 Nov 2020 16:16:04 GMT

I have a line chart which is sales values from 2005 to 2025.

2005 to 2016 is actual data

2016 to 2025 is forecast data

using if(year<=2016,'<S1>','<S3>') able to differentiate actual vs Forecast,

i have one more requirement like expression label also

if(year<=2016,'Actual','forecast') whichi given in expression lable but it is not workling

Can any body do the needful for dynamic label in line chart.

Thanks

Thiru

awhitfield — Mon, 11 Jul 2016 10:29:40 GMT

Hi Thiru,

can you upload an example QVW please?

Andy

sunny_talwar — Mon, 11 Jul 2016 10:43:13 GMT

Is this something you are trying to do for a legend?

Mon, 11 Jul 2016 10:46:54 GMT

Hi Sunny,

Yes

when we keep our cursor on the chart,the label and the value will be appear right.

My case it is showing sales actual for entire line,but i want to show Actual and Forecast based on year

Thiru

sunny_talwar — Mon, 11 Jul 2016 10:55:52 GMT

May be using 2 expressions instead of 1?

Mon, 11 Jul 2016 12:09:36 GMT

Hi Sunny

Thanks,Ok.

I will use this as of now.If any solution is available please let me know

Thiru

Anil_Babu_Samineni — Mon, 11 Jul 2016 12:32:21 GMT

As i understand, You should need to write Condition from General Tab