# New to QlikView

Discussion board where members can get started with QlikView.

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
Contributor III

## Need help with set analysis

Try:

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

3 Replies
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])

Contributor III

## Need help with set analysis

Try:

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

Highlighted
Not applicable

## Need help with set analysis

Thanks so much.  I appreciate your quick response.