Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Need help with a chart

Hi All

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

User_LocationEmployee_CountMonth
Athens12Mar-13
Amsterdam13Mar-13
UK15Mar-13
Athens14Apr-13
Amsterdam13Apr-13
UK16Apr-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-13Apr-13
Athens1214
Amsterdam1313
UK1516
Tags (1)
1 Solution

Accepted Solutions
sushil353
Honored Contributor II

Re: Need help with a chart

hi,

Please find attached

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

HTH

Sushil

3 Replies

Re: Need help with a chart

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    

sushil353
Honored Contributor II

Re: Need help with a chart

hi,

Please find attached

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

HTH

Sushil

Not applicable

Re: Need help with a chart

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.

Community Browser