Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nawazuddin234
New Contributor III

Cummulative Supplier Count

Hi All,

I am trying to calculate cumulative supplier count by using the below expression with an "if "condition in it .But Im getting an error can anyone help me ,

=RangeSum(above(count(distinct if(vSpendType = 'Sourceable', (if(is_sourceable = 'Y', amount))

, if(vSpendType = 'SC Manageable', (if(is_sc_manageable = 'Y', amount))

  ,Supplier))),0,rowno()))

TIA.

digvijay

1 Reply
MVP
MVP

Re: Cummulative Supplier Count

Don't know what exactly you are doing in this expression but I can suggest something like below.

=RangeSum(Above(Count(Distinct If(vSpendType = 'Sourceable' and is_sourceable = 'Y', amount,If(vSpendType = 'SC Manageable' and is_sc_manageable = 'Y', amount,Supplier))),0,RowNo()))




Community Browser