topic Re: Expression inside p() or e() indirect set analys in QlikView

Expression inside p() or e() indirect set analys

Wed, 20 Nov 2013 14:38:21 GMT

lets supose we have a value V and a dimension D1,D2

It would be possible to make a indirect calculation like sum( D1=p(SUM(D2)=5) VALUE)

In this case we only want to sum those D1 VALUES where sum(D3)=5

Regards

Re: Expression inside p() or e() indirect set analys

datanibbler — Wed, 20 Nov 2013 14:42:06 GMT

Hi Victor,

surry, but - is this a question?

Re: Expression inside p() or e() indirect set analys

swuehl — Wed, 20 Nov 2013 14:51:08 GMT

I don't think that

sum( D1=p(SUM(D2)=5) VALUE)

is valid syntax and will work as you want.

Maybe you can use an advanced search:

sum( {< D1= {"=sum(D2)=5"} >} VALUE)

Re: Expression inside p() or e() indirect set analys

Wed, 20 Nov 2013 14:52:07 GMT

Excuse me I forgot the question mark :

lets supose we have a value V and a dimension D1,D2

It would be possible to make a indirect calculation like sum( D1=p(SUM(D2)=5) VALUE) ?

In this case we only want to sum those D1 VALUES where sum(D3)=5

the question is i don't want the "sum" expression to be like sum(TOTAL D2) I WANT TO SUMMARIZE SUM(D2) FOR EACH D1 particularly so "sum expression" couldn't be inside "$()"

Regards

Re: Expression inside p() or e() indirect set analys

Wed, 20 Nov 2013 23:11:14 GMT

I knew that it existed that you called "advanced search" and was looking some tutorial about the syntax. could you please explain to me the rules of that kind of syntax. Thanks a lot. Is there a tutorial in any place?