Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I'm writing to solicit your help for a qlikview report.
I would like to know if what i need is possible, what's the best way and charts to do this.
My goal :
I have a historical table in which i insert unpaid customer's informations.
I have a DATE_INSERT field for the insert date.
If i have to date 17/09/2019 and 18/09/2019, I would like to analyze customer's evolution between these two dates.
I would like to know if there are the same customers in the two dates and the evolution of the unpaid bills.
thanks a lot.
Try to create a table where customer is your dimension and these two measures
=Sum( {<
DATE_INSERT={'$(=minstring(DATE_INSERT))'}
>}UnpaidAmount)
=Sum( {<
DATE_INSERT={'$(=maxstring(DATE_INSERT))'}
>}UnpaidAmount)
You should adjust the aggregation to fit your data, it could be sum(UnpaidAmount) as above but even Count(BillID) or similar.
Try to create a table where customer is your dimension and these two measures
=Sum( {<
DATE_INSERT={'$(=minstring(DATE_INSERT))'}
>}UnpaidAmount)
=Sum( {<
DATE_INSERT={'$(=maxstring(DATE_INSERT))'}
>}UnpaidAmount)
You should adjust the aggregation to fit your data, it could be sum(UnpaidAmount) as above but even Count(BillID) or similar.
You can create a Grid or Bar chart with multi dimension ( Date , Customer) and expression as unpaid bills for your view
Harry, did either of the posts help you with things, or are you still trying to figure things out? If you have a solution and either of the posts helped, be sure to use the Accept as Solution button to give them credit for the help. If you did something different, consider posting that solution and then after you post it, mark it as the solution using the button I mentioned above. If you still need assistance, provide an update.
Regards,
Brett