Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mario_ti
Not applicable

How to show curve b (of the abc curve) in a kpi?

How to show curve b (of the abc curve) in a kpi?

2 Replies
beck_bakytbek
Not applicable

Re: How to show curve b (of the abc curve) in a kpi?

Hi Mario,

please give a screenshot of your extpected output

Beck

mario_ti
Not applicable

Re: How to show curve b (of the abc curve) in a kpi?

Well, it's a simple thing to sum (value) only the products that belong to curve b .. of the curve abc ... I already have

if (RangeSum(Above(

Sum({$<COD={'1','3','12','13'}>} [VALUE]), 1, RowNo ()), Sum({$<COD={'1','3','12','13'}>} [VALUE]))/Sum({$<CD_FIL={'1','3','12','13'}>} TOTAL [VALUE])< 0.50, 'A',

if (RangeSum(Above(

Sum({$<COD={'1','3','12','13'}>} [VALUE]), 1, RowNo ()), Sum({$<COD={'1','3','12','13'}>} [VALUE]))/Sum({$<COD={'1','3','12','13'}>} TOTAL [VALUE])< 0.80, 'B',

if (RangeSum(Above(

Sum({$<COD={'1','3','12','13'}>} [VALUE]), 1, RowNo ()), Sum({$<COD={'1','3','12','13'}>} [VALUE]))/Sum({$<COD={'1','3','12','13'}>} TOTAL [VALUE])< 0.999999, 'C',

'-')))

But I would like to display in a SIMPLE KPI only the value of CURVE B