Hi guys,
I am relatively new to qlikview and was trying to create a stacked bar chart, however, there is an issue.
The data that i am dealing with is in regards to sales and delivery and returns. so, for this example, each month, there are sales and also deliveries. I.e a customer may order a good in January but recieve his item in february. I wanted to depicts this in one stacked bar chart in qlikview like how i am able to do in excel with the x-axis holding the respective months.
The problem here is manipulating the 2 dimensions for them to read the information for each customer record correctly on the stacked bar chart.
In the excel sheet attached the amber bar represents the sales month, Delivery Month represented by the green bar and returns represented by the blue bar.
