Load In Line in script - Apply this in a combo Chart

[lessassy]

Hello everyone,

I have several bar charts which display some values (let's say sales) based on weeknumber (at the format YYYY-MM) for  and month (at the format monthname-YYYY)

I used a cycle group to display week value and month value. I'm using a master calendar

But the issue is every year the target evolved.

And each year there is a month target and in some case a week target.

And i want to say to qlik view if the weeks or month belongs to a specifi year then apply the target to this specific month or week.

I tried this I tried if(year="maxstring(Year)",Target()) but it didn't work.

So I searched and used the script to load the data i wanted

But when I use the combo chat and use that as line it doesn't work either

I don't know what the proper formula it is to display the line chart.

Can someone help please

[joseph_eftamand]

Hi Yann,

You need to do some kind of aggregation. For example do Sum(LBU).

What is the dimension in this chart? If I understand correctly are you using your Inline table to map to the original target table?

Joseph