Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dvasseur
Partner - Creator III
Partner - Creator III

global vision of data available every day

Hello,

I have an application dealing with shares, each share having an 'in' date (bought) and an 'out' date (sold) and the value of the share.

Now I would like to display for each calendar date the global value of all shares available at this date.

Data:

sharein (dd/mm/yyyy)out (dd/mm/yyyy)value
A01/01/200810/01/200810
B07/01/200813/01/200830
C02/01/200804/01/200820
D05/01/200815/01/200840


Result wanted:

01/01/200810
02/01/200810+20 = 30
05/01/200810+40 = 50


I can get it if I select a specific date but not for a global vision

See attached QVW

Regards,

David

2 Replies
Not applicable

Hi David,

just an idea. See the attached example for details.

Good luck!

Rainer

dvasseur
Partner - Creator III
Partner - Creator III
Author

Hi Rainer,

I have to check if it can be done with my real data (and millions of records updated frequently), I would have prefered a dynamic solution but good idea anyway, thanks!

David