topic Re: Distinct with Sum - Set Analysis in QlikView

Distinct with Sum - Set Analysis

Mon, 27 May 2013 17:09:17 GMT

Dear,

I need to Tab 01 and Tab 02 generate in Qlikview.

I am trying to Sum ({$} Sales) DISTINCT [Number]) but does not work, can someone help me?

Tab 01

Number	Sales	Status
001111	57,02	A
001111	57,02	B
001111	57,02	C
001111	57,02	A
001456	15,06	C
001456	15,06	B
012579	1,60	A
012963	3,9	A
012963	3,9	B

Tab 02 - Correct

Number	Sales
001111	57,02
001456	15,06
012579	1,60
012963	3,9
Total	77,58

Re: Distinct with Sum - Set Analysis

Gysbert_Wassenaar — Mon, 27 May 2013 17:12:24 GMT

Use Number as dimension and max(Sales) or min(Sales) or avg(Sales) as expression. Set the Total Mode of the expression to sum of rows. Or use as expression sum(aggr(max(Sales),Number)).

Re: Distinct with Sum - Set Analysis

Mon, 27 May 2013 17:30:42 GMT

Distinct in thought because of the following situation.

See attached, please.

Re: Distinct with Sum - Set Analysis

Mon, 27 May 2013 18:21:17 GMT

A light???

Re: Distinct with Sum - Set Analysis

Mon, 27 May 2013 19:22:17 GMT

Hi,

Rebeca

Re: Distinct with Sum - Set Analysis

nagaiank — Mon, 27 May 2013 19:44:05 GMT

The following script may be of help.

Data:

LOAD * INLINE [

Number, Sales, Status

001111, 57.02, A

001111, 57.02, B

001111, 57.02, C

001111, 57.02, A

001456, 15.06, C

001456, 15.06, B

012579, 1.60, A

012963, 3.9, A

012963, 3.9, B

002939, 1.4, B

002939, 1.4, C

];

Result:

NoConcatenate

LOAD Distinct Number, Sales Resident Data;