Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fredericvillemi
Creator III
Creator III

Set analysis question

Hi,

i have a document with many dimensions : project, customer, dimension1, dimension2

i want to create a chart with an amount total which will be always the amount total for the selected "project" without looking at any other dimension.

I mean, i want to have the total only based on one filter, project

how can i do that with set analysis  (or with another way) ?

Thanks

1 Solution

Accepted Solutions
Not applicable

sum({1<Project=P()>} Field)

View solution in original post

5 Replies
Not applicable

sum({1<Project=P()>} Field)

Not applicable

Hi Frederic,

I think this can be done by using the following expression :--

sum({<customer=,dimension1=,dimension2=,project=$(=only(project))>}field)

v_iyyappan
Specialist
Specialist

Hi,

     use like this

      = sum(TOTAL field)

Regards

Iyyappan

fredericvillemi
Creator III
Creator III
Author

Great, exactly what i wanted

and imagine i would like to add another dimension, how can i do it ?

only project and customer ?

Thanks

Not applicable

That is simple, just copy the syntax with a coma after to add more:

sum({1<Project=P(),customer=P()>} Field)