topic Simple Question For A New User in QlikView

Simple Question For A New User

Wed, 16 Sep 2009 01:18:53 GMT

Hello:

I have just started working with QlikView Desktop and I am having some trouble with what seems to be a simple task. I have fields called "Manufacturer", "Brand", "Month01", "Month02", "Month03:, etc. that I would like to view in a simple Table Box. When I select a Manufacturer and then a Brand from the existing Manufacturer and Brand List Box, the Table Box is showing the Brand multiple times. What I would like to do is show only the distinct Brand once in the Table Box along with the totals for each Month. Is this doable?

Thank you.

Simple Question For A New User

Wed, 16 Sep 2009 01:43:34 GMT

So you want:

Customer Jan 50
 Feb 60
 Mar 100

Your data is not set up the best way for this, but it is doable. You really want: Manufacturer, Brand, Month, Amount. So each Month is actually a separate record. In order to get your data looking like that, you should look into Cross Table in the QlikView help.

Alternatively, you could make a separate expression for each month. Exp 1: Sum(Month01); Exp 2: Sum(Month02), etc.

Then, in both cases, you would probably want to use a pivot to have the Customer only appear once and each Month totalled. If you use a Straight Table, the Customer would be repeated for each Month.

Simple Question For A New User

Wed, 16 Sep 2009 01:55:18 GMT

Hello:

Actually, I want:

Manufacturer Brand Month01 Month02 Month03

Man1 Brand1 17 26 25

Dependent on which Manufacturer and Brand are selected. What I am seeing is:

Manufacturer Brand Month01 Month02 Month03

Man1 Brand1 2 10 1

Man1 Brand1 6 4 12

Man1 Brand1 1 9 5

Man1 Brand1 8 3 7

Simple Question For A New User

Wed, 16 Sep 2009 01:58:14 GMT

as nmiller said, you need a pivot with dimensions for manufacturer & brand and a sum() per month as expression

Simple Question For A New User

Wed, 16 Sep 2009 03:01:30 GMT

Thank you all. Extremely helpful!

Simple Question For A New User

Wed, 16 Sep 2009 03:02:32 GMT

A table box just lists out the rows as it is. So create a chart. Select the type as Pivot Table.

Add following dimensions:

Manufacturer,Brand,Month

Add one expression:

sum(Amount)

Now you will get one table which looks somewhat like this

Manufacturer	Brand	Month	Amount
M1	B1	Jan	100
		Feb	200
		Mar	300

Now click on the Month column and drag it above the 'Amount' cell. The table will look like this

Manufacturer	Brand	Jan	Feb	Mar
M1	B1	100	200	300