Excel Sumif function

[New-Qlik]

HI

I have to get below output

Customer	aaa= c1+c2+c3	bbb	ccc
product	Sales
p1	40	20	30
p2	40	20	30
p3	40	20	30

My source file is

customer	sales	Product
c1	10	p1
c2	10	p1
c3	20	p1
bbb	20	p1
ccc	30	p1
c1	10	p2
c2	10	p2
c3	20	p2
bbb	20	p2
ccc	30	p2
c1	10	p3
c2	10	p3
c3	20	p3
bbb	20	p3
ccc	30	p3

[francisvandergr · Accepted solution]

You can do this with Set analasys. See example.

sum( {$<customer = {"c*"}-{"ccc"}>} sales )

sum( {$<customer = {"bbb*"}>} sales )

sum( {$<customer = {"ccc"}>} sales )

[New-Qlik]

Thanks A lot Francis

[New-Qlik]

how can I change name of customer to aaa ,

I cannot do in expression label name as it should be sales

Customer	aaa= c1+c2+c3		bbb		ccc
product	Sales	%	Sales	%	Sales	%
p1	40	33.33333333	20	33.33333	30	33.33333
p2	40	33.33333333	20	33.33333	30	33.33333
p3	40	33.33333333	20	33.33333	30	33.33333
total	120	100	60	100	90	100

[francisvandergr]

can you post your qvw?

[New-Qlik]

Hi Farancis,

I have calcualated % in yours only .

I have to menation name like aaa,bbb and ccc

n below is sum(sales) and % for each customer

[francisvandergr]

with labels

[New-Qlik]

For all expressions I have lables like same and %

what I am not getting how to show customer name, if I pick another dimension then how can I say c1,c2,c3 combines label is aaa