Distinct with Sum - Set Analysis

[#1]

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

[Gysbert_Wassenaar]

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)).

[#3]

Distinct in thought because of the following situation.

See attached, please.

[#4]

A light???

[#5]

Hi,

Rebeca

[nagaiank]

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;