Hider Bars in accumulated combo chart with Last Year vs Fiscal Year comparison
Hello, I’m trying to create an accumulated bar chart comparison with the Cost for Last Year. I am using a combo chart and when looking at the YTD values it doesn’t stop at the last Period that has values.So I’m trying to somehow hide the bars that do not have a new value. I tried coloring them with ARGB and make them transparent which partly works, but unfortunately also hides last years values (the line).I already found some threads, but they were based on qlikview and I could not make it work with the help I found regarding sense on the forum.
So everything crossed with black should not be visible, either through making it transparent or not showing up at all. Can anyone help?
I tried to attach a qvf based on my bar chart, I hope I uploaded it correctly. You will have to select FY2019 to see the correct view with the missing values for bars from periode 4 on.