# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Give me the AR day number when cash hits 99%

Dear.

I have created a pivot table with the following data:

Row: [AR day nbr] - gives me the day number of AR

Collumn: [Inv Year Month]

Measures:

=rangesum(above(Sum({<[Type]={'APP'},[Cash App Type]={'CASH'}>}[AR USD]*(-1))
/
sum({<[Type]={'INV'},[Rebill Indicator]={'Non Rebill'}>}total<[AR Year Month]>[AR USD]),0,RowNo()))

Result is:

 AR  ay Nbr Inv  Month Feb 2017 -13 3.0% -12 4.3% -11 5.3% -10 6.4% -9 6.8% -8 8.2% -7 8.5% -6 13.3% -5 17.3% -4 20.4% -3 24.3% -2 28.0% -1 28.4% 0 63.0% 1 64.6% 2 77.2% 3 81.8% 4 84.4% 5 85.6% 74 98.6% 75 98.6% 76 98.6% 89 98.6% 90 98.7% 91 98.7% 93 98.7% 94 98.7% 95 98.8% 96 98.7% 97 98.7% 98 98.7% 99 98.7% 111 98.9% 112 98.9% 113 98.9% 114 99.0% 115 99.0% 116 99.0% 125 99.1%

Now I want to create a KPI where I can show in the KPI what the the day number is when hit the number >99%. For an example, in the example used above the KPI should show me 114.

Thanks a lot.

Ugur

Labels (4)

• ### rangesum

5 Replies
Valued Contributor III

## Re: Give me the AR day number when cash hits 99%

only( {<AR  ay Nbr={"=rangesum(above(Sum({<[Type]={'APP'},[Cash App Type]={'CASH'}>}[AR USD]*(-1))
/
sum({<[Type]={'INV'},[Rebill Indicator]={'Non Rebill'}>}total<[AR Year Month]>[AR USD]),0,RowNo()))>99"}>} AR  ay Nbr)

try

Channa
MVP

## Re: Give me the AR day number when cash hits 99%

Will you always check this for a single Inv Month or can you have more than a single month? If you have more than one month, what would the result be in that case if 99% falls on a different number for two different months.

Contributor

## Re: Give me the AR day number when cash hits 99%

Hi Thanks a lot,

only( {<[AR day Nbr]={"=rangesum(above(Sum({<[Type]={'APP'},[Cash App Type]={'CASH'}>}[AR USD]*(-1))
/
sum({<[Type]={'INV'},[Rebill Indicator]={'Non Rebill'}>}total<[AR Year Month]>[AR USD]),0,RowNo()))>99"}>} [AR day Nbr])

and it says error, is there something I do wrong?

Contributor

## Re: Give me the AR day number when cash hits 99%

only( {<[AR day Nbr]={"=rangesum(above(Sum({<[Type]={'APP'},[Cash App Type]={'CASH'}>}[AR USD]*(-1))
/
sum({<[Type]={'INV'},[Rebill Indicator]={'Non Rebill'}>}total<[AR Year Month]>[AR USD]),0,RowNo()))>99"}>} [AR day Nbr])

and it says error, is there something I do wrong?

Thanks

Contributor

## Re: Give me the AR day number when cash hits 99%

Hi

I only want to have it for specific month.

Thanks

Ugur