Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

     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

4 Replies
datanibbler
Champion
Champion

Hi Victor,

surry, but - is this a question?

swuehl
MVP
MVP

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)

Not applicable
Author

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

Not applicable
Author

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?