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: 
Not applicable

How to write in Set Analysis

Hi All,

Though its Friday, but still I am here to bug and buzz.

How do i write this following statement in set analysis,

sum(total if(FACT_TYPE='Current' AND FLAG_HEALTH_REPORT='1' AND STAGE<> 'Lost' AND STAGE <> '-' AND STAGE <> 'Expired' AND STAGE <>'Design Win' AND STAGE <> 'Project Cancelled',TOTAL_VALUE))

Thanks,

Bikash

1 Solution

Accepted Solutions
Not applicable
Author

can y try this one

sum({<FACT_TYPE={'Current'},FLAG_HEALTH_REPORT={1} ,STAGE-= {'Lost','-','Expired','Design Win','Project Cancelled'} >}TOTAL_VALUE))

View solution in original post

1 Reply
Not applicable
Author

can y try this one

sum({<FACT_TYPE={'Current'},FLAG_HEALTH_REPORT={1} ,STAGE-= {'Lost','-','Expired','Design Win','Project Cancelled'} >}TOTAL_VALUE))