I need to calculate an annualized volume for the current year. I have 7 years worth of data and only half a years worth of data for 2018. I want to sum the volumes for years 2011-2017, but want to multiply the 2018 volume by 2 to get an annualized estimate. I am trying the "if then else" function to no avail, i.e., if Year='2018', then (volume*2), else volume. Seems like it should be simple but I am not making progress. Any direction you could provide would be greatly appreciated...thank you!!!
Try sum(if(Year=2018,2,1)*volume). If that doesn't work we'll need more information. Please post a small Qlikview or Qlik Sense app that demonstrates the problem.
Try sum(if(Year=2018,2,1)*volume). If that doesn't work we'll need more information. Please post a small Qlikview or Qlik Sense app that demonstrates the problem.
