Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Contributor II
Contributor II

Brilliant, thank you!