Line chart question

Mon, 06 Oct 2014 16:35:02 GMT

Hi,

I have to make a line chart based on an expression

(num/den)*rev

which I wrote as

(max(aggr(max({<Month= {'9'},

Year={'2013'}

>}Num),Day,Prod,SubRegion,Region))

max(aggr(max({<Month= {'9'},

Year={'2013'}

>}Den),Day,Prod,SubRegion,Region)))

(max(Aggr(max({<Month= {'9'},

Year={'2014'}

>}[Revenue]),Day,Prod,SubRegion,Region)))

Now the dimension for the chart is Day

What is happening is that I have Num and Den values for all days of the month but the Revenue Value Is just for 15 days..so the chart stops at day 15. These values for a particular prod,subRegion and Region stay same for the entire month so is there a way that I can make qlikview make the entire line chart till day 30 by taking the revenue value for that particular prod,subRegion and region on the day 15 and using it till the end of the month ?

topic Line chart question in QlikView

Line chart question