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 ?