create an expression

QSense — Tue, 20 Nov 2012 11:14:54 GMT

İn my qw ,

I wanto to create second expression

İt must include ISTEK_DURUM='Açık' and ISTEK_AÇISTARIHI2 older than 30 days before selected ISTEK_ACISTARIHI2

when I select ISTEK_DURUM as 'Açık' and date older than 30 days from ISTEK_ACISTARIHI2 it must count affected rows

=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')	ISTEK_DURUM
19.11.2012	Açık	Dimension	=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')
12.11.2012	Açık
05.11.2012	Kapalı
29.10.2012	Açık
22.10.2012	Kapalı
15.10.2012	Açık
08.10.2012	Açık
01.10.2012	Açık

I can explain in sample.

In list above I want to display in chart and my dimension as you see.

but my need is that When I looked in 05.11.2012 date I want to display 30 days and older before 05.11.2012 date and ISTEK_DURUM="Açık"

For each date I would like to see this information

For instance from the wiew of 19.11.2012 how many request satisfy my need

these three rows satsify my need

topic create an expression in QlikView