Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rafael5958
New Contributor III

sum values on table

Hello, I have, for example, a xls like this:

     

customercustomer IDCompanySupplier Suplier IDValue
Kurt1AAAKmart1200
Kurt1AAAKmart1300
Kurt1AAAKmart1300
Kurt1AAAKmart1300
Kurt1AAAKmart1300
Kurt1AAAGmart2150
Kurt1AAAHmart323
Kurt1AAAJmart450
Dave2AAAKmart110
Dave2AAAGmart210
Dave2AAAHmart310
Dave2AAAJmart410
Chris3BBBKmart150
Chris3BBBGmart250
Chris3BBBHmart3

50

and I need to put this in a table like this:

     

Supplier Suplier IDDiferent CustomersDifferent CompaniesTotal
Kmart1321460
Gmart232210
Hmart33283
Jmart42160

How can I do it, Im trying in a dinamic table, but couldnt figure it out, how can I do all the sum.

Thanks.

Tags (1)
1 Solution

Accepted Solutions

Re: sum values on table

This?

Capture.PNG

Dimensions: Supplier, Supplier ID

Expressions:

1) =Count(DISTINCT customer)

2) =Count(DISTINCT Company)

3) =Sum(Value)

1 Reply

Re: sum values on table

This?

Capture.PNG

Dimensions: Supplier, Supplier ID

Expressions:

1) =Count(DISTINCT customer)

2) =Count(DISTINCT Company)

3) =Sum(Value)

Community Browser