Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Roling 12 month in minichart

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)

  • This variable contains:

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 😞

error loading image

When I make a new chart, use the same kpi dimension, add yearmonth and the same expression, $(vLast12Month), it works

error loading image

However, when I select a month, the minichart isn't working anymore but in a regular bar chart everything is working fine:

error loading image

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!

0 Replies