Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

I'm getting married - Application

OmarBenSalem
Esteemed Contributor

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

Comments
JustinDallas
Valued Contributor

Is there an app we can download?

OmarBenSalem
Esteemed Contributor

I'll attach the app and the excel files

naman_mittal
New Contributor III

Cool...thats great!!!

OmarBenSalem
Esteemed Contributor
balanandam
Contributor II

So interesting.... Pls. add this app

OmarBenSalem
Esteemed Contributor

I just can't edit the article.. don't know why? mto

YoussefBelloum
Esteemed Contributor

Congrats !

souma2020
New Contributor III

Inspiring & Awesome!

Congrats

kamalqlik
Valued Contributor

Nice One

sbflyboy
New Contributor III

Nice work can you get it to do write backs.

Version history
Revision #:
1 of 1
Last update:
‎11-24-2017 11:05 AM
Updated by: