SUMIFS in Qlik

[Anonymous]

Hi

I am new to Qlik and I was usually using Excel in before.

Here is a case I would like to use something similar to "SUMIFS" but I am not quite sure how to write in on Qlik.

For example:

Type	Value	SUMIFS
A	10	30
B	35	45
A	20	30
B	10	45

I have a "Type" column and "Value" column. I would like to sum all the value according to the "Type" and show the total of each type in the "SUMIFS" Column.

Could anyone suggest a method for me how to work on this kind of situation?

Many Thanks.

Felix

[sunny_talwar]

Try this

Dimension

Type

Value

Expression

Sum(TOTAL <Type> Value)

[ahmar811]

Hi,

Please use below script and also find attached qvw file for your reference.

TabA:

load * Inline [

Type, Value

A ,10

B ,35

A ,20

B ,10

];

Left Join

load Type, Sum(Value) as SUMIF

Resident TabA Group by Type;

Output:

Regards

Ahmar