topic Re: p() in set analysis in QlikView

p() in set analysis

jduluc12 — Tue, 26 Sep 2017 12:25:21 GMT

HI,

I want to write an expression to include amount only for those customer whose name starts with "ABC" but does not have address which starts with "XYZ"

sum({<Customer=p{1<Name={'ABC*'}, Address={'*'} - {'XYZ'}>Customer}>}Amount)

it is not working and it behaves exactly like as if the statetment is

sum({<Customer=p{<Name={'ABC*'}>Customer}>}Amount)

what am i doing wrong?

Thanks

Re: p() in set analysis

sunny_talwar — Tue, 26 Sep 2017 12:27:19 GMT

May be this

Sum({<Customer = p({1<Name={'ABC*'}, Address=-{'XYZ*'}>} Customer) >}Amount)

Re: p() in set analysis

jduluc12 — Tue, 26 Sep 2017 12:30:38 GMT

nope...it is not working

i tried that

Re: p() in set analysis

hari8088 — Tue, 26 Sep 2017 12:32:41 GMT

May be like this..

sum({<Customer=p{1<Name={'ABC*'}, Address-={'XYZ*'}>Customer}>}Amount)

Re: p() in set analysis

sunny_talwar — Tue, 26 Sep 2017 12:34:12 GMT

Have you made sure that p is followed by '(' and ends with ')'... you don't have () and there were other issues....

Re: p() in set analysis

jduluc12 — Tue, 26 Sep 2017 12:36:12 GMT

This the exact statement that i have written.

and p is followed by ( and ends with )

Re: p() in set analysis

sunny_talwar — Tue, 26 Sep 2017 12:40:15 GMT

Do you see an error or 0?

Re: p() in set analysis

jduluc12 — Tue, 26 Sep 2017 12:47:44 GMT

here is the whole expression

sum({<Month=, Year=,Number=,[Type={‘Regular’}, Account={‘def’}>

* 1<Memo=p({<Memo=,Name={‘ABC*’}, [Address]=-{‘XYZ’}>}Number)>}Amount)

Re: p() in set analysis

sunny_talwar — Tue, 26 Sep 2017 12:53:32 GMT

Address starts with XYZ or is XYZ? You don't have an asterisk for Address?

sum({<Month=, Year=,Number=,[Type={‘Regular’}, Account={‘def’}>

* 1<Memo=p({<Memo=,Name={‘ABC*’}, [Address]=-{‘XYZ*’}>}Number)>}Amount)

Re: p() in set analysis

jduluc12 — Tue, 26 Sep 2017 12:53:53 GMT

the strange part is

if i remove - from [Address]=-{‘XYZ’} then it works perfectly according to the expression i.e. it brings only those names who’s address starts with XYZ

sum({<Month=, Year=,Number=,[Type={‘Regular’}, Account={‘def’}>

* 1<Memo=p({<Memo=,Name={‘ABC*’}, [Address]={‘XYZ’}>}Number)>}Amount)

Re: p() in set analysis

effinty2112 — Tue, 26 Sep 2017 13:43:09 GMT

Maybe:

sum({$<Customer = {'ABC*'}>*<Address -={XYZ*}>}Amount)

Good luck

Andrew