topic Re: Compare data between to period in QlikView

Compare data between to period

marakud971 — Wed, 18 Sep 2019 16:22:30 GMT

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.

Re: Compare data between to period

Vegar — Wed, 18 Sep 2019 16:41:27 GMT

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.

Re: Compare data between to period

qliksus — Thu, 19 Sep 2019 05:07:46 GMT

You can create a Grid or Bar chart with multi dimension ( Date , Customer) and expression as unpaid bills for your view

Re: Compare data between to period

Brett_Bleess — Mon, 30 Sep 2019 18:02:53 GMT

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