topic Aggregating rows for display in QlikView

Aggregating rows for display

Tue, 28 Feb 2012 20:40:20 GMT

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.

Aggregating rows for display

jagan — Wed, 29 Feb 2012 07:59:39 GMT

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.

Re: Aggregating rows for display

mdmukramali — Wed, 29 Feb 2012 08:21:57 GMT

Dear,

find the attachment.

Aggregating rows for display

Wed, 29 Feb 2012 16:10:11 GMT

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?

Aggregating rows for display

jagan — Thu, 01 Mar 2012 05:12:11 GMT

Hi,

Use CustomerName, ProductName, Country as dimensions and use

=Sum(Qty-Ly)

=Sum(Qty-CY)

as expressions

Regards,

Jagan.

Aggregating rows for display

CELAMBARASAN — Thu, 01 Mar 2012 05:19:36 GMT

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