Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Daniel_K
New Contributor II

How to calculate the financial value of invoices received and cleared within 1 day of receiving them

Hello,

I'm looking for help to calculate the financial value of invoices received and cleared within 1 day of receiving them to help ensure we're achieving a KPI

Data set example:

SupplierInvoice numberInvoice valueDate receivedDate cleared for payment
Supp1Invoice110001/05/201901/05/2019
Supp1Invoice210001/05/201901/05/2019
Supp1Invoice320001/05/201901/05/2019
Supp1Invoice420001/05/201901/05/2019
Supp1Invoice520001/05/201901/05/2019
Supp1Invoice630001/05/201903/05/2019
Supp1Invoice730001/05/201903/05/2019
Supp1Invoice810001/05/201903/05/2019
Supp1Invoice910001/05/201903/05/2019
Supp1Invoice1010001/05/201903/05/2019

 

Expected chart output summary based on the above information

SupplierDate receivedNumber of invoicesOverall valueCleared within 24hrsCleared within 72hrs
Supp101/05/2019101700800900
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to calculate the financial value of invoices received and cleared within 1 day of receiving

Cleared within 24hrs: sum( {<[Invoice number]={"=[Date cleared for payment]-[Date received]<1"}>} [Invoice value])


talk is cheap, supply exceeds demand
2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to calculate the financial value of invoices received and cleared within 1 day of receiving

Cleared within 24hrs: sum( {<[Invoice number]={"=[Date cleared for payment]-[Date received]<1"}>} [Invoice value])


talk is cheap, supply exceeds demand
Daniel_K
New Contributor II

Re: How to calculate the financial value of invoices received and cleared within 1 day of receiving

Brilliant, thank you!