I'm new to qlikview and trying to figure out, how to get a year-over-year comparsion with a set analysis formula, that works for a multiple quarter selection and a single quarter comparison.I have list boxes for years and quarters, so it is possible to select either (1) a single quarter, (2) multiple quarters such as Q1+Q2 or (3) make no selection which should calculate the variance based on the latest available quarter.
The formulas below do only work for one or the other but not all of the possible selections. I have read a lot of posts in the community about prior year comparisons but wasn't really able to adapt or understand the presented solutions. Maybe there is an "easy" solution that I am not aware of.
