how to use sum() with multiple fields using and

[mansi_dv]

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 · Accepted solution]

Hi,

Try below syntex.

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

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

[jjordaan]

Hi Mansi,

You can try this.

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

[sushil353]

Hi Mansi,

Try this:

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

HTH

Sushil

[#5]

Hi,

Try with below one

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

[CELAMBARASAN]

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]

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