Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Need help with set analysis

I need help determining why I am not get any results for this set analysis below. 

SUM({$<[Est Cost], [Work Flow Doc Type] -= {'UE - *','CO *', 'CM*'}>} DISTINCT [WO ID])

I am trying to get the total for the estimated cost of planned work orders.  I am getting 0 right now.

1 Solution

Accepted Solutions
jduenyas
Contributor III

Need help with set analysis

Try:

SUM({$<[Work Flow Doc Type] -= {'UE - *','CO *', 'CM*'}>}[Est Cost])

3 Replies
Employee
Employee

Need help with set analysis

Try the expression partially as below to see if you can identify the failing part. If this doesnt give you any clues, please proivde a sample QVW so that the chart object can be evaluated.

SUM(DISTINCT [WO ID])

SUM({$<[Est Cost]>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'UE - *'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'CO *'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'CM*'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'UE - *','CO *'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'CO *', 'CM*'}>} DISTINCT [WO ID])

SUM({$<[Work Flow Doc Type] -= {'UE - *', 'CM*'}>} DISTINCT [WO ID])


jduenyas
Contributor III

Need help with set analysis

Try:

SUM({$<[Work Flow Doc Type] -= {'UE - *','CO *', 'CM*'}>}[Est Cost])

Not applicable

Need help with set analysis

Thanks so much.  I appreciate your quick response.

Community Browser