topic Re: Difference between two expressions in QlikView

Difference between two expressions

Mon, 07 Jul 2014 10:32:48 GMT

test:

load * Inline

[

Test_A, Test_B, Test_C

10.001, 20, 1

31, 1, 2

];

QUALIFY * ;

test_1:

load sum(Test_A) - sum(Test_B) as TOTAL

Resident test

group by Test_C;

test_2:

load sum(Test_A - Test_B) as TOTAL

Resident test

group by Test_C;

Is there a difference in this two differents ways to calculate sum ?

(In my example this is exactly the same, but in my application with huges datas there are difference and I think is due to this calculation)

Thanks

Re: Difference between two expressions

whiteline — Mon, 07 Jul 2014 10:45:41 GMT

Hi.

In some cases they can give different results.

Suppose that for some records the Test_B is null(). Then the second expression will skip the whole record even if the Test_A is not null, because Test_A - null() = null()

Re: Difference between two expressions

maxgro — Mon, 07 Jul 2014 10:51:46 GMT

maybe if you have some null in your application data

result

script

test:

load rowno() as id, Test_A, if(Test_B='-',null(),Test_B) as Test_B, Test_C;

load * Inline

[

Test_A, Test_B, Test_C

100, 10, 1

100, 1, 2

100,-,1

];

QUALIFY * ;

test_1:

load Test_C, sum(Test_A) - sum(Test_B) as TOTAL

Resident test

group by Test_C;

test_2:

load Test_C, sum(Test_A - Test_B) as TOTAL

Resident test

group by Test_C;

Re: Difference between two expressions

SunilChauhan — Mon, 07 Jul 2014 10:55:50 GMT

first expression is f sum of differnce

where as second is difference of sum