max value display

[kunkumnaveen]

Hello all,

sample data

when i select max date i was suppose to get 500 as value but i am getting 0

Varibles:

vMindate = 3sep;

vMaxdate = Date;

expression:=sum({<Date={"$(vMindate)"}>}value)  = 100

                   sum({<Date={"$(vMaxdate)"}>}value) =500 (Not Working)

wats going wrong in my above statement?

thanks

[kunkumnaveen]

no..getting same o/p 0

[settu_periasamy]

Is that date format? Can you share the sample qvw?

[kunkumnaveen]

Hello,

[Chanty4u]

u can create

in script

load *,

MONTH(Datefield) as month

day(datefield) as day

den u can use variable

[tamilarasu · Accepted solution]

Have a look at the attachment.

[settu_periasamy]

try this

=sum({<Date={"$(=$(vMaxdate))"}>}value)

[kunkumnaveen]

[kunkumnaveen]

=sum({<Date={"$(vMindate)"}>}value)

[maniram23]

Hi,

It is help full for you.