topic Re: Aggr in Search the Community

Aggr

manoranjan_d — Thu, 25 Feb 2021 14:54:11 GMT

Hi all,

Below is my script and chart details

ProductData:

LOAD * inline [

Customer|Product|UnitSales|UnitPrice

Astrida|AA|4|16

Astrida|AA|10|15

Astrida|BB|9|9

Betacab|BB|5|10

Betacab|CC|2|20

Betacab|DD|25|25

Canutility|AA|8|15

Canutility|CC||19

] (delimiter is '|');

Chart Dim: Product

Chat exp : Aggr(Sum(UnitSales), Customer)

For AA,CC,DD I m getting Null value which is not correct and please sort out this issue

my expected o/p is

Re: Aggr

manoranjan_d — Sun, 21 Feb 2021 22:51:27 GMT

Any experty can help me on this

Re: Aggr

Saravanan_Desingh — Mon, 22 Feb 2021 00:16:14 GMT

The Null shows that there are more than one Customer for that Product.

You can simply use Sum(UnitSales)

If your requirement is different, then let me know the expected result.

Re: Aggr

manoranjan_d — Mon, 22 Feb 2021 19:11:33 GMT

I tried with same scenario like one employee name with different company where its getting correct.

PFA

Re: Aggr

manoranjan_d — Wed, 24 Feb 2021 03:01:26 GMT

Hi saran or qlik experty waiting for ur reply to understand aggr

Re: Aggr

manoranjan_d — Thu, 25 Feb 2021 14:56:47 GMT

updated my expected o/p in the first post

Re: Aggr

manoranjan_d — Thu, 25 Feb 2021 15:01:09 GMT

you can download the files in my thread i shared , which have two scenarios of aggregation one is passed and one is failed.

required o/p for failed scenario :

Re: Aggr

manoranjan_d — Thu, 25 Feb 2021 18:37:35 GMT

Any qlik experty to reply for aggr function

Re: Aggr

Saravanan_Desingh — Thu, 25 Feb 2021 19:33:22 GMT

Your Chart has Dimension - Product.

But your Expression has Dimension as Customer. Please correct this.

Try this:

Chart Dim: Product, Customer

Chat exp : Aggr(Sum(UnitSales), Customer, Product)

Also I could not understand how you are getting 23 for AA.

Re: Aggr

manoranjan_d — Thu, 25 Feb 2021 19:39:23 GMT

its simple aggr function i dont want to add the customer.

i want to understand the aggr function.

if see in to excel file same concept with different data , there it is passing , but where else in customer, product,sales data its falling see the difference in the Qlik file.