Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
kevincagle
New Contributor III

Question: Use QlikView to compare year over year on line chart

First off, I am new to Qlikview. I have some of the basic navigation down but not very familiar with the operation. It is a large program with so much power available. Honestly its a little intimidating, but all things are when you first jump into it. I look forward to learning this application from all sides.

I have a question that I cant seem to find an answer to (that doesn't involve the scripting which I haven't gotten into yet). I have an excel spreadsheet with 10,000+ rows with a similar format to the example below.

Example Spreadsheet shortened : Color for Year 2011 changed for easy identification of year.

 

   

YearMonthLocationShelfCategorySubCatVolume
2010JanRack 1 Prime ColorRed12
2010JanRack 1 Prime ColorBlue15
2010JanRack 1 ColorGreen4
2010JanRack 1 ColorOrange6
2010JanRack 1 ColorPurple77
2010JanRack 1 Prime ColorYellow1
2010JanRack 1 ColorBlack12
2010JanRack 1 NonColorWhite15
2010FebRack 2 Prime ColorRed4
2010FebRack 2 Prime ColorBlue6
2010FebRack 2 ColorGreen77
2010FebRack 2 ColorOrange6
2010FebRack 2 ColorPurple1
2010FebRack 2 Prime ColorYellow5
2010FebRack 2 ColorBlack4
2010FebRack 2 NonColorWhite48
2011JanRack 1 Prime ColorRed16
2011JanRack 1 Prime ColorBlue115
2011JanRack 1 ColorGreen114
2011JanRack 1 ColorOrange16
2011JanRack 1 ColorPurple177
2011JanRack 1 Prime ColorYellow12
2011JanRack 1 ColorBlack112
2011JanRack 1 NonColorWhite115
2011FebRack 2 Prime ColorRed116
2011FebRack 2 Prime ColorBlue418
2011FebRack 2 ColorGreen522
2011FebRack 2 ColorOrange366
2011FebRack 2 ColorPurple17
2011FebRack 2 Prime ColorYellow96
2011FebRack 2 ColorBlack81
2011FebRack 2 NonColorWhite19


I need to make a line chart that shows the change in Volume for Category, organized by Rack (shelf not as important), for the Year 2011 listed month by month compared to Year 2010.


I can set a line graph that shows one or 2 of the dimensions I need but cant figure out how to expand so it will show the other dimensions.

realize there may be a limit to whether Rack can show month to month over 2 years factoring Category in a standard line graph. In this scenario, would Combo Chart be a feasible option to generate the desired results? How would I set the varying dimensions?

I'm not asking someone to do it for me because I prefer to learn how its done. If someone does make it for me I ask that an explanation of how to do it be included with it.

Thank you for any guidance provided.

Kevin.

PS: My apologies if this is posted in the incorrect sub-forum. New to this style of forum.

1 Solution

Accepted Solutions
shiveshsingh
Honored Contributor

Re: Question: Use QlikView to compare year over year on line chart

use this expression

sum({<Year = {'2010'}>}Volume)

sum({<Year = {'2011'}>}Volume)


and add dimension as Category and Month

6 Replies
shiveshsingh
Honored Contributor

Re: Question: Use QlikView to compare year over year on line chart

You can put two expression, one for 2011 and other for 2010 ..for calculating the Volume.

In dimension, u can set the required dimension.

kevincagle
New Contributor III

Re: Question: Use QlikView to compare year over year on line chart

Im not sure I understand how, but here is what's coming to mind.

Properties-->Expressions-->Add:

Year(2011)

-->Add:

Year(2010)

Or is there more to it?

Then I would need to do what in the dimensions properties?

Im wrong or messed up somewhere but it seems Dimensions only factors the top 2 entries, of which I currently have Month, Location, Year, Category set in that order.

shiveshsingh
Honored Contributor

Re: Question: Use QlikView to compare year over year on line chart

Expressions like,

sum({<Year = {'2010'}>}Volume)

sum({<Year = {'2011'}>}Volume)

shiveshsingh
Honored Contributor

Re: Question: Use QlikView to compare year over year on line chart

May be this

kevincagle
New Contributor III

Re: Question: Use QlikView to compare year over year on line chart

Unfortunately I cannot view your file. QlikView Personal limitations in effect.

shiveshsingh
Honored Contributor

Re: Question: Use QlikView to compare year over year on line chart

use this expression

sum({<Year = {'2010'}>}Volume)

sum({<Year = {'2011'}>}Volume)


and add dimension as Category and Month