topic Need help with set analysis in QlikView

Need help with set analysis

Thu, 15 Mar 2012 20:11:08 GMT

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.

Need help with set analysis

ToniKautto — Thu, 15 Mar 2012 21:07:45 GMT

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

Need help with set analysis

jduenyas — Thu, 15 Mar 2012 21:11:05 GMT

Try:

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

Need help with set analysis

Thu, 15 Mar 2012 22:04:21 GMT

Thanks so much. I appreciate your quick response.