I'm getting married - Application

    Hi folks; I'm getting married on the 14th of April 2018 (You're all invited of course ! ); and as you all know, the act of marriage demands a lot of expenses (and deep LOVE, obviously ! ).

    So, to make things clearer and easier to me, and know exactly where my money is going, and who contributed (members of my family ) with me, I thought about creating an application with Qlik Sense, to track all of this and created it :

    The source is 3 excel tables :

     

    1) a table where all the expenses are stored (the actual expense, its budget and the contributor):

    Capture.PNG

     

    2) a table where we can find the initial contribution of anyone (then we track how much is left depends on actual expenses)

    Capture.PNG

    3) a table to describe what has been bought:

    Capture.PNG

     

    Some tranformations have been made in the script to fill the blanks and calculate new fields:

    Capture.PNG

    This application is updated to (24/11/2017); hope you like it :

    1st sheet to track what's going on:

    Capture.PNG

    2nd sheet to see each one's contribution in details:

    Capture.PNG

    3rd sheet to track how much is left of each one's initial contribution based on his/hers actual expenses:

    Capture.PNG

     

    The application on action:

     

    Omar BEN SALEM.

    Qlik Consultant.

     

    Ce document a été généré à partir de la discussion suivante :I'm getting married - Application