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: 
Mkh13646
Contributor
Contributor

show sum of value till specific month and for specific class

Hi everyone, 

I would like to show the sum of project progress which their activities class is "develop"  till the specific month ([MRS_PRJ_PROG.CURMONTH]) in my cell of a table, I write this code but it doesn't work, I appreciate  if anyone can help me to make this work

If(Valuelist('Lastmonth','Frombegin')='Frombegin', If(FMONTH <=[MRS_PRJ_PROG.CURMONTH],Sum({<TYPE_ = {"DEVELOP"}>}[MRS_PRJ_PROG.PROG_]))

 

Labels (1)
0 Replies