Aggregating rows for display

[#1]

I have a single table in load statement. It has some measures and dimension (attributes).

Country

Region

State

State ID

Sales

I want to display a report with Country & Sales Income only. I do that but when i see the report on IE it repeats the country value for all stateID's. I just want to see one row per country with sum(Sales). It is a simple group by in SQL but I don't want to do it on LOAD statement as I want to use the state info in another tab.

[jagan]

Hi,

Add Country as Dimension in chart and use =Sum(Sales) as Expression.

This will show Country and their corresponding sales.

Hope this helps you.

Regards,

jagan.

[mdmukramali]

Dear,

find the attachment.

[#4]

Dear All ,

Let me explain again what I want:

My qlickview dataset

Customer ID	Customer Name	Product ID	Product Name	Country	Qty-Ly	Qty-CY
1	ABC Inc	101	Shoes	Japan	1	2
2	ABC Inc	102	Shoes	Japan	2	3
3	ABC Inc	103	Shoes	Japan	5	7
4	XYZInc	110	jackets	China	4	10
5	XYZInc	110	jackets	China	5	11

I am using a Table object and only picking the following data items:

Customer Name

Product name

Country

Qty-Ly

Qty-CY

The following data is displayed in Qlikview

Customer Name	Product Name	Country	Qty-Ly	Qty-CY
ABC Inc	Shoes	Japan	1	2
ABC Inc	Shoes	Japan	2	3
ABC Inc	Shoes	Japan	5	7
XYZInc	jackets	China	4	10
XYZInc	jackets	China	5	11

What I really want

Customer Name	Product Name	Country	Qty-Ly	Qty-CY
ABC Inc	Shoes	Japan	8	12
XYZInc	jackets	China	9	21

How to achieve it without modifying the Load statement?

[jagan]

Hi,

Use CustomerName, ProductName, Country as dimensions and use

=Sum(Qty-Ly)

=Sum(Qty-CY)

as expressions

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     Use Straight table instead of table box.

     Have dimensions CustomerName, ProductName, Country.

     Have expressions below

     =Sum(Qty-Ly) give label for this as Qty-Ly

     =Sum(Qty-CY) give label for this as Qty-CY

Celambarasan