topic Re: how to use sum() with multiple fields using and in QlikView

how to use sum() with multiple fields using and

mansi_dv — Wed, 19 Mar 2014 06:42:35 GMT

Hi,

I have a situation where I want to get data which satisfies 2 conditions in pivot table expression.

I tired this statement and found result is correct.

=sum({<[Quarter] = {"Q1"}>}Data)

But I want to check for 2 conditions like

quarter = Q1

and

month = june

I tried

=(sum({<[Quarter] = {"Q1"}>}Data) and sum({<[Month] = {"June"}>}Data))

but I am getting -1 as answer.

Can someone please suggest the solution?

kumarnatarajan — Wed, 19 Mar 2014 06:48:42 GMT

Hi,

Try below syntex.

1. =Sum({$<Quarter={"Q1"},Month={"June"}>}Data)

2. =Sum({$<Quarter={"Q1"}>*<Month={"June"}>}Data)

jjordaan — Wed, 19 Mar 2014 06:49:23 GMT

Hi Mansi,

You can try this.

Sum({$<[Quarter] = {"Q1"}> + <[Month] = {"June"}>} Data)

sushil353 — Wed, 19 Mar 2014 06:50:49 GMT

Hi Mansi,

Try this:

=Sum({$<Quarter={"Q1"},Month={"June"}>}Data)

HTH

Sushil

Wed, 19 Mar 2014 06:55:07 GMT

Hi,

Try with below one

=sum({<[Qtr] = {$('Q1')}, Month = {('June')}>} Data)

CELAMBARASAN — Wed, 19 Mar 2014 06:55:09 GMT

Hi,

If you want to and operation btw two conditions then use

Sum({<[Quarter] = {"Q1"},[Month] = {"June"}>} Data)

for OR condition use

Sum({<[Quarter] = {"Q1"}>+<[Month] = {"June"}>} Data)

mansi_dv — Wed, 19 Mar 2014 07:14:45 GMT

Thanks Kumar Natrajan, Jeroen Jordaan, Sushil Kumar, Qlikview Qlikview and Celambarasan Adhimulam. It works.