Discussion Board for collaboration on QlikView Layout & Visualizations.
I need some help creating a chart. I have the following data:
over time, I will have data for each month going forward. I like to create a chart like this below but I'm not sure how to do so:
Please find attached
for this just creat a pivot chart and put month dimension horizontally.
View solution in original post
Create a pivot table with dimension as User_Location and Month.
Expression as sum(Employee_Count)
then click on the Month dimension label, hold the click and then drag it on the expression.
Thank you both for your help. I never knew that you can do that with Dimensions. Would never have look for how to drag the dimensions as you had described.