topic sum in different items in the same row in QlikView

sum in different items in the same row

pgalvezt — Tue, 10 Jan 2012 23:15:15 GMT

Hi,

I have a pivot table with many rows and colums. The first one has a list of products, the second one has date for each specific product an d the third column has valus in format money. What I need to do? I need to sum. Item 1 of the first product with the item 1 of the second product. Then a new row would be Item 2 of the first product with the item 2 of the second product.

Thanks!

Re: sum in different items in the same row

Sokkorn — Wed, 11 Jan 2012 01:15:21 GMT

Hi,

I'm not sure it can be done by chart. But let try via below script

[Data]:
LOAD * INLINE [
Product    ,    LeadTime    ,    Value
A    ,    61 - 90 Days    ,    10000
A    ,    91 - 120 Days    ,    5000
A    ,    121 + Days    ,    12000
A    ,    Seriously Past Due    ,    4000
B    ,    61 - 90 Days    ,    15000
B    ,    91 - 120 Days    ,    8000
B    ,    121 + Days    ,    2000
B    ,    Seriously Past Due    ,    11000];
Types:
LOAD fieldvalue('Product',iterno()) as Product
AUTOGENERATE 1
WHILE len(fieldvalue('Product',iterno()));
Totals:
LOAD
 'Total' as TypeGroup,
 Product
RESIDENT Types;
CONCATENATE (Totals)
LOAD
 Product as TypeGroup,
 Product
RESIDENT Types;
DROP TABLE Types;

Take TypeGroup and LeadTime as dimension, SUM(Value) as expression

Check the sample attached file also.

Hope this help.

Regards,

Sokkorn Cheav

Re: sum in different items in the same row

pgalvezt — Wed, 11 Jan 2012 13:51:13 GMT

Thanks for your reply, this its really works, but Im trying with div and didn't work. How can I do this?

Re: sum in different items in the same row

pgalvezt — Wed, 11 Jan 2012 15:01:25 GMT

Any Idea?

Thanks!

Re: sum in different items in the same row

pgalvezt — Thu, 12 Jan 2012 11:58:05 GMT

Div require 2 values. In this case how can I do it?

Re: sum in different items in the same row

pgalvezt — Thu, 12 Jan 2012 13:16:58 GMT

Anyone?

sum in different items in the same row

Thu, 12 Jan 2012 14:37:58 GMT

Hi,

I'm not use to understand. You probably have to use a set analysis.

Could you give an example?

Re: sum in different items in the same row

pgalvezt — Thu, 12 Jan 2012 14:42:02 GMT

The answer is on the top. But now I need to do the same thing but with DIV numeric fuction.

Thanks!

Re: sum in different items in the same row

pgalvezt — Thu, 12 Jan 2012 15:56:05 GMT

I hope you understand the question.

Thanks!