Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Highlighted
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
Highlighted
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

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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    

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
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

View solution in original post

Highlighted
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.