topic Re: Use Up to date criteria in QlikView

Use Up to date criteria

anuradhaa — Mon, 02 Mar 2015 10:38:39 GMT

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 — Mon, 02 Mar 2015 10:40:13 GMT

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

anuradhaa — Mon, 02 Mar 2015 10:46:44 GMT

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 — Mon, 02 Mar 2015 10:50:39 GMT

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

anuradhaa — Mon, 02 Mar 2015 11:06:13 GMT

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 — Mon, 02 Mar 2015 11:16:36 GMT

Provide your sample apps or data !

anuradhaa — Mon, 02 Mar 2015 12:08:48 GMT

Hi Please use this qvw.

anuradhaa — Mon, 02 Mar 2015 12:16:19 GMT

Pls use this