Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
marakud971
New Contributor III

Compare data between to period

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.

3 Replies
Partner
Partner

Re: Compare data between to period

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. 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
qliksus
Valued Contributor II

Re: Compare data between to period

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

Support
Support

Re: Compare data between to period

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.