data problem

Mon, 15 Feb 2016 08:17:36 GMT

i use this formula to calculate this data AUM

Date Field	AUM
1	10
4	20
5	21
6	22
7	23
9	24
10	25
11	26
15	27

=sum({$<[Execution Date]={'$(Vmaxdate)'},max({<[Execution Date] = {"<$(=max([Execution Date]))"}>}[Execution Date])>}AUM)

when i use this formula =date(max({<[Execution Date] = {"<$(=max([Execution Date]))"}>}[Execution Date]),'DD-MMM-YYYY')

for calculating last date it works well but while summing it gives me 0.please check this where i am going wrong also attached qvd if found a solution.

Re: data problem

sunny_talwar — Mon, 15 Feb 2016 16:31:32 GMT

There is nothing attached. Would you be able to share a sample?

topic data problem in QlikView

data problem

Re: data problem