I think I have found a bug in the minichart. The minichart is showing strange behaviour when I try to create a roling 12 month.
I have around twenty KPI's for which I need to show the last 12 months. The model is designed around one fact table for all KPI's, so all relevant information can be showed in just one chart and can be exported to excel with one click.
To keep things manageble there is an object oriented approach with variables:
- The chart has the expression:
$(vLast12Month)
if(KPI=1,$(vKPI1Last12Month),
if(KPI=2,$(vKPI2Last12Month), etc etc
- The $(vKPILast12Month) contains the real expression for the roling 12 month for the particular KPI.
Individually, all variables are tested and working however, the minichart does not work 😞
When I make a new chart, use the same kpi dimension, add yearmonth and the same expression, $(vLast12Month), it works
However, when I select a month, the minichart isn't working anymore but in a regular bar chart everything is working fine:
I think it is the variable into the variable in combination with the minichart which Qlikview does not like. Could this be a bug in the minichart? Anyone have seen problems like this before.. any solutions maybe? Thanks!