Plot a stacked bar chart with 4 dimensions and rate axis
I have a stacked bar chart with 5 dimensions. I am trying to plot the them as 5 measures of different scale. The sample data is attached. i need to plot the amounts in left axis and the rate in Y axis in Qlikview.
Can anyone help me in acheiving the same in Qlikview?
When i plot this in primary and secondary axis, iam getting the graph like below. Its dynamically plotting the x values. Can it be as in the excel graph