topic Re: Need help with a chart in QlikView

Need help with a chart

Mon, 11 Mar 2013 17:46:46 GMT

Hi All

I need some help creating a chart. I have the following data:

User_Location	Employee_Count	Month
Athens	12	Mar-13
Amsterdam	13	Mar-13
UK	15	Mar-13
Athens	14	Apr-13
Amsterdam	13	Apr-13
UK	16	Apr-13

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:

	Mar-13	Apr-13
Athens	12	14
Amsterdam	13	13
UK	15	16

Re: Need help with a chart

kaushiknsolanki — Mon, 11 Mar 2013 17:56:07 GMT

Hi,

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.

Regards,

Kaushik Solanki

Re: Need help with a chart

sushil353 — Mon, 11 Mar 2013 17:58:47 GMT

hi,

Please find attached

for this just creat a pivot chart and put month dimension horizontally.

HTH

Sushil

Re: Need help with a chart

Mon, 11 Mar 2013 19:03:21 GMT

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.