topic Re: Satisfy expression conditions in QlikView

Satisfy expression conditions

QSense — Mon, 19 Nov 2012 17:32:55 GMT

=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

Hello everyone,

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

15.10.2012	Açık
08.10.2012	Açık
01.10.2012	Açık

How can I write an expression to satisfy my need from the each date view?

Re: Satisfy expression conditions

QSense — Mon, 19 Nov 2012 18:02:23 GMT

It will be like Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açik'}>} ISTEK_ACISTARIHI2) but here expression always gets today as based date I want to make my dimension date as based date field

Dimension:date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')

Re: Satisfy expression conditions

QSense — Mon, 19 Nov 2012 19:43:15 GMT

As you see above, Count(if(ISTEK_ACISTARIHI2 >=30,ISTEK_ACISTARIHI2, ISTEK_DURUM='Açık')) wtih this expression , ıt brings total amount 8 but ıt should bring zero since ISTEK_ACISTARIHI2 is not older than 30 days

if ISTEK_ACISTARIHI2 older than 30 days and ISTEK_DURUM ='Açık' , ıt must count total rows both satisfies two conditions