Use Up to date criteria

[anuradhaa]

Hi,

I need to display date the values less than selected date in a table.

say if i select 2015 jan,

i need to display all date values less than or equal to 2015 jan.

Thank You

[MK_QSL]

SUM({<Date = {"<=$(=Date(Max(Date)))"}>}Value)

[anuradhaa]

Hi ,

where do i need to put this? in date select box.

if my data field is mydate and i have table with different values, how do i select value.

please explain that expression a bit

[MK_QSL]

You can use this expression in Chart or Table expression..

[anuradhaa]

Here in my date select box i have date name "startdate" - Year and month

then in my bar chart i use

month as dimension.

and expression

=AVG({$<IND={'A'}>}(enddate-startdate))

How to use that expression with this data

[MK_QSL]

Provide your sample apps or data !

[anuradhaa]

Hi Please use this qvw.

[anuradhaa]

Pls use this