topic Re: Excel Sumif function in QlikView

Excel Sumif function

New-Qlik — Wed, 25 Nov 2020 16:16:04 GMT

I have to get below output

My source file is

francisvandergr — Sun, 14 Aug 2016 19:36:03 GMT

You can do this with Set analasys. See example.

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

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

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

New-Qlik — Sun, 14 Aug 2016 20:10:53 GMT

Thanks A lot Francis

New-Qlik — Sun, 14 Aug 2016 20:38:10 GMT

how can I change name of customer to aaa ,

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

francisvandergr — Sun, 14 Aug 2016 20:45:47 GMT

can you post your qvw?

New-Qlik — Sun, 14 Aug 2016 21:03:19 GMT

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 — Sun, 14 Aug 2016 21:18:18 GMT

with labels

New-Qlik — Tue, 16 Aug 2016 06:57:54 GMT

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