topic Re: subtract two expression in qlikview in QlikView

subtract two expression in qlikview

capriconuser — Mon, 04 Mar 2019 06:09:38 GMT

i have expression like this

sum({code={'654','2','131'}>} Amount)

(fabs(sum(distinct{<category={'1005'},code={'2'}>} Amount}

fabs(sum(distinct{<category={'1005'},code{'45'}>} Amount )))

sum(distinct{<category={'12','34','56','78','90'},code={'56'}>} Amount )

now the second expression which is

(fabs(sum(distinct{<category={'1005'},code={'2'}>} Amount}

fabs(sum(distinct{<category={'1005'},code{'45'}>} Amount )))

i want to modify this only in 1 line like this look category is same but code is different so is this possible to subtract like this ?

(fabs(sum(distinct{<category={'1005'},code={'2'} - code ={'45'}>} Amount}

any help

Re: subtract two expression in qlikview

NhanNguyen — Mon, 04 Mar 2019 06:22:52 GMT

This should work?

(fabs(sum(distinct{<category= {1005,2} - {45}>} Amount}

Re: subtract two expression in qlikview

capriconuser — Mon, 04 Mar 2019 06:56:18 GMT

no.

(fabs(sum(distinct{<category= {1005,2} - {45}>} Amount}

here category is only 1005 and transaction code are 2 and 45 .. so i want minus between codes not categories

Re: subtract two expression in qlikview

NhanNguyen — Mon, 04 Mar 2019 07:23:56 GMT

Ok, now I understand. A one-line expression like you proposed is not working since set analysis will exclude data not deduct values. So you must write 2 expressions.