Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

disregarding the selection but not the dimension by AGGR

Hi and thanks for tahks for the  attentions.

i have this problem, in a dimension i should calculated progress disregarding all selections but not dimension.

to semplify the question my problem is:

why this formula considering the selection?

=sum({1}aggr(nodistinct WEIGHT,PROJECT_NAME,WBS_NAME,TF_NAME,INT_TF_NAME,DISC_NAME,INT_DISC_NAME,EMC_NAME,INT_EMC_NAME,ACTIVITY_NAME,JOB_DOC_ID)) 

if no selections formula gives the correct sum weight of a documents but if I filter one document returns the weight of the document selected also I use {1} in sum function

Many thanks,

Kinney

2 Replies
Gysbert_Wassenaar

Try: =sum({1}aggr(nodistinct only({1} WEIGHT), PROJECT_NAME, WBS_NAME, TF_NAME, INT_TF_NAME, DISC_NAME, INT_DISC_NAME, EMC_NAME, INT_EMC_NAME, ACTIVITY_NAME, JOB_DOC_ID))


talk is cheap, supply exceeds demand
Not applicable
Author

many thanks,i'll try to work with only function.