I have two fields, 1. Cluster(group of states), 2. Country. i want country in dimension and cluster in expression in stacked format. and the total should show in line at top. I need help to achieve this.
It looks kind of not possible in Qlikview in direct way caz when we try to plot line chart where individual totals are cluster totals, they cannot be plotted against the overall dimension of the chart which are both cluster group and country.
When I tried to use Aggr by cluster, Qlikview stopped showing me stacked option in style tab. I could achieve the attached one only so far.