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

lessassy — Mon, 28 May 2018 19:47:33 GMT

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

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

joseph_eftamand — Thu, 21 Jun 2018 11:57:43 GMT

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

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

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

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