topic Aggregation Issue in QlikView

Aggregation Issue

renjithpl — Mon, 24 Mar 2014 11:21:16 GMT

Hi All,

I have attached a qvw where my data aggregates same for all available ID's.

Please have a look at this and suggest the possible way to get this done.

Regards

Ren

Re: Aggregation Issue

Mon, 24 Mar 2014 11:40:59 GMT

prepare your trasaction as follows :

Transaction:

Load *,

rowno() as Rowno

from XXX

;

add rowno in chart dimension

Re: Aggregation Issue

its_anandrjs — Mon, 24 Mar 2014 11:47:06 GMT

Hi,

Load like this

Transaction:

LOAD * INLINE [

ID, Amount

IAA, 200

IAA, 300

IBB, 400

];

Left Join

LOAD * INLINE [

ID, SubName

IAA, Puma1

IAA, Puma2

IBB, xyz

];

Main:

LOAD

RowNo() as Rownum

Resident Transaction;

DROP Table Transaction;

And in chart add Rownum as dimension and if you dont want to display this then hide this from

Chart properties -> Presentation -> Select column name and hide column

Hope this helps

Thanks & Regards

Re: Aggregation Issue

arsal_90 — Mon, 24 Mar 2014 11:48:08 GMT

Please find the attached file for ur solution

Re: Aggregation Issue

renjithpl — Mon, 24 Mar 2014 11:53:56 GMT

Hi Muhammad the answer looks fine for me, i will test this and get back to you.. till then its a helpful answer.. Will do a unit test before implementing this logic.. thanks

Re: Aggregation Issue

ThornOfCrowns — Mon, 24 Mar 2014 11:55:42 GMT

Nice solution.

Re: Aggregation Issue

arsal_90 — Mon, 24 Mar 2014 12:22:12 GMT

ok no issue

Re: Aggregation Issue

its_anandrjs — Mon, 24 Mar 2014 12:37:54 GMT

Hi,

You can do this way also for aggregation

LOAD * INLINE [

ID, Amount

IAA, 200

IAA, 300

IBB, 400

];

LOAD * INLINE [

ID, SubName

IAA, Puma1

IAA, Puma2

IBB, xyz

];

NoConcatenate

MainA:

load

ID as IDkey,

Amount,

RowNo()&'/'&ID as Key

Resident A;

DROP Table A;

NoConcatenate

MainB:

LOAD

ID as IDkey2,

SubName,

RowNo()&'/'&ID as Key

Resident B;

//RENAME Field ID to IDkey;

DROP Table B;

Hope this helps

Thanks & Regards

Re: Aggregation Issue

renjithpl — Tue, 25 Mar 2014 10:44:36 GMT

Its not working for this example..

Transaction:

ID	Amount
PROWARTRUS	254,837,905.07
PROWARTRUS	24,106,288.29
HBSTRUNO1	60,092,758.35
HBSTRUNO1	296,689,271.56
PUMASTS8-1	77,957,351.00
PUMASTS8-1	171,344,128.00
PUMASTS8-1	30,000,000.00
PUMASTS8-1	65,800,000.00

Master:

ID	SubName
PUMASTS8-1	PUMA Masterfund S-8 (Class A2)
PUMASTS8-1	PUMA Masterfund S-8 (Class AB)

Re: Aggregation Issue

arsal_90 — Tue, 25 Mar 2014 19:13:05 GMT

Hi Renjith

Basically if i m not wrong you are dealing with Master data sales.

Let suppose 2 categories: Category for Toy Sub category for toy

generally if sales Occurred then sales table i mean transaction tables also hit with sub category. Let suppose if u r in a shop and buy Toys. so transaction table hit with Sub category. there are two brands in Sub category : Puma1 and Puma 2 but both are belongs to Category Field in which category is Puma. So what u want is logically not possible for huge data. Please elaborate your database table in detail and whats your requirement?