How to analyse changes of data between two dates ?

marakud971 — Thu, 24 Oct 2019 15:57:21 GMT

Hi everybody,

I need your help !

if you look at the example in attachment (Presentation.png)

I would like to analyze the evolution of the amount of the invoices of my customers between two dates.
I would like to display in one table the amount for the two dates (both dates are selected by the user) and also the progress of the payment.

The dimensions used are : dimension "customer contract" (num police) and dimension "bill number" (%Q_NUM).
A customer can have multiple bills.

I would like to have the evolution by contract and also by invoice.

What I have done

For the min date :

=sum(aggr(Sum( {<

DATE_INSERT={'$(=minstring(DATE_INSERT))'}

>} Q_ARRIERE), %Q_NUM))

For the max date :

=sum(aggr(Sum( {<

DATE_INSERT={'$(=maxstring(DATE_INSERT))'}

>} Q_ARRIERE), %Q_NUM))

For comparaison :

=((Column(1)-Column(2))/Column(1))

I am experiencing the following issues :

(Picture 1.png)
I would like to delete null invoices (0 €),
In my mindate colunm.
Because it does not make sense in the monitoring of payments.
(Picture 2.png)
When I select a contract number,
Amounts of the datamax change.
And When I select a bill number amounts change again.

Can you tell me if my method is good, ?
How to change my code to solve problems ?
Also, what type of graph adapted to this type of analysis i could add ?

Thanks a lot.

topic How to analyse changes of data between two dates ? in QlikView

How to analyse changes of data between two dates ?