Max Date using Filename

Thu, 27 Mar 2014 06:17:01 GMT

Hi,

Please help me with the following task:

Ii have Data as :

Name 1 2 3 4 5 6 7 8 9

A 10 20 30 100 121 131 200 300 400

B 11 21 31 101 122 132 201 301 401

C 12 22 32 102 123 133 202 302 402

D 13 23 33 103 124 134 203 303 403

F 14 24 34 104 125 135 204 304 404

Note: Day pick from top header

Month&year pick from filename

And my Requirement is :

Date Name Value

Max date A sum(Values)

Max date B sum(Values)

Max date C sum(Values)

Max date D sum(Values)

Max date F sum(Values)

For example:

Thanks

Ankit

topic Max Date using Filename in QlikView