topic Re: set analysis in QlikView

set analysis

mario-sarkis — Thu, 18 Jun 2015 13:57:14 GMT

hey all

please my question is i have this table

has duplicate in ids but i need to calculate the sum of amount ignoring the duplicates i dont want to do the sum for the same iD twice:

ID Amount

1 1000

2 2000

3 1500

4 2500

sum(amount)=7000

1000+2000+1500+2500 ( this the sum that i want )

ihave to use distinct ID if yes how can i use it

Thanks

giakoum — Thu, 18 Jun 2015 13:59:22 GMT

distinct them while you load them

tablename:

load distinct

ID, Amount from .....

alexandros17 — Thu, 18 Jun 2015 14:00:47 GMT

Use this expression in your chart: (ID as dimension)

Sum(Aggr(Amount, ID))

sunny_talwar — Thu, 18 Jun 2015 14:01:22 GMT

In the front end you can try this expression in a text box:

=Sum(Aggr(Avg(Amount), ID))

mario-sarkis — Thu, 18 Jun 2015 14:21:33 GMT

if ia have many dimenssion in my table example

ID type sort amount

it should be like this Sum(Aggr(Amount, type ,sort,ID)) ?

sunny_talwar — Thu, 18 Jun 2015 14:25:37 GMT

If you want distinct across all the dimensions, then add those as well.

alexandros17 — Thu, 18 Jun 2015 14:27:17 GMT

Maybe, I should have to take a look to the document

Anonymous — Thu, 18 Jun 2015 17:59:31 GMT

=Sum(DISTINCT Amount)