Add in Year-to-Date or average column in bar chart
I have really struggled to find an answer to this on the qlikview community as I currently only have the Personal edition and cannot open files to look at what people did - any answers please screenshot/type what you did as I won't be able to see the answer otherwise!
I want to add a YTD column in my bar chart of Visits per Day (VPD). This would be the average of all the months up until the current Month ( Month < Month(Today()) or something like this), where for each month and for the YTD there is: a box plot for the objective VPD, a symbol for the previous year VPD and a symbol for the actual VPD this year.
Also, I would like a column that shows the forecasted total year VPD, (that also shows the total year objective and previous year).
If this doesn't make sense, happy to answer more questions but I have attached a qlikview file with example data.
As I mentioned initially, please can you describe/screenshot/type example expressions here as I will not be able to open a new version of the document
Re: Add in Year-to-Date or average column in bar chart
Do you have a master calendar in your data set?
if not, that's step 1, as that will allow you to use the various date flags in your set expressions. (The below will work but you may need to change DATE_KEY to whatever date attribute you have in your data set)