Set analysis - Brackets produce different result

Tue, 22 Jan 2013 10:27:27 GMT

Hello,

does anyone know, why these two formulas produce different results?

Sum ({$<GegenkontoGEDREHT-={">=(9000)<=(9100)"}, VerdNr={">=1030<=1039"}>} [UmsatzGEDREHT])

Sum ({$<GegenkontoGEDREHT-={">=9000<=9100"}, VerdNr={">=1030<=1039"}>} [UmsatzGEDREHT])

The only difference is the "()" after "GegenkontoGEDREHT". The document works just fine for me, I simply would like to understand why Qlikview treats those two formulas differently. One time displaying the "9000" value in "GegenkontoGEDREHT" and on the second example not.

Any ideas?

Thees

Re: Set analysis - Brackets produce different result

Tue, 22 Jan 2013 11:01:44 GMT

hi,

as per my anlysis:

if you place brackets as you told, then set anlysis is ingnoring those values.

hence we are getting 0 as sum.

using brackets will not give correct results, better avoid.

Niranjan M.

topic Re: Set analysis - Brackets produce different result in QlikView

Set analysis - Brackets produce different result

Re: Set analysis - Brackets produce different result