Qlik Community

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
Highlighted
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])


Highlighted
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.