Qlik Sense - Bar chart with drill down dimension and target for each level
Greetings!
I would like to display a column chart with a drill-down dimension, where each level corresponds to separate goals. However, the sum/average of the lower-level goals does not roll up to the higher-level goal. Therefore, I cannot represent the same hierarchy in the goals. Do you have any ideas on how to visualize this and what code should be built for it? I am attaching a picture of how the goal values currently look.
