Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
princyal
Contributor III
Contributor III

Show the selected field Max date Value

Hi,

 

I have Fund field and Assets Field .When i  select Date field  i want the  fund field max date and sum(Assets).

eg :

suppose i select fund 3 i want the max date of 30/11/19 sum(Assets)

i attached my sample data

please help any one as soon as possible

thank you

 

Labels (1)
17 Replies
princyal
Contributor III
Contributor III
Author

Ok , thank You

 

i am waiting for the positive answer

sunny_talwar

positive answer?

princyal
Contributor III
Contributor III
Author

I am waiting for the positive reply.

last two days i am working on this requirement i asked many people no one can solve this problem

Now for me  your the only hope for me to solve my problem 

sunny_talwar

I want to help, but I need to understand what you are doing? Can you provide the output for the above set of data that I provided?

Rodj
Luminary Alumni
Luminary Alumni

@princyal I fear we've missed your deadline for getting this worked out. Despite best efforts we haven't had enough information on the challenge you are facing to be able to help by the looks of it. As per Sunny's reply, if you still want to resolve this we just need some more detail on exactly what your data looks like and what you trying to achieve.

princyal
Contributor III
Contributor III
Author

Hi,

Again I attached my sample data. This is my actual data format So much data only even I received, the client requirement is

 If I selected 30/09/19 I would just sum the first 3 records for Fund1,fund2, Fund3 (8000+10000+7000)

So, if I select Reportdate=30/11/209, I would get the sum of assets marked in yellow colors are 

if  I select Reportdate=30/12/209 on that Fund4, Fund5, Fund 6 is repeated again (10000+15000+20000-5000+5000+10000)

 

princyal
Contributor III
Contributor III
Author

hi ,

This Is My Actual Data so much data only we received from client

ravi200351023
Contributor II
Contributor II

try this one

 

AAA:
LOAD [Check No],
Report_Date,
Fund,
Assets
FROM
[111.txt]
(txt, codepage is 28591, embedded labels, delimiter is '\t', msq);

Temp:
load
[Check No],
Report_Date,
Fund,
Assets,
numsum( Assets, Peek( 'Bsum' ) ) as Bsum
resident AAA order by
Report_Date,
Fund;

drop table AAA;

output:

output.jpg