topic Re: Expression about date in QlikView

Expression about date

QSense — Mon, 19 Nov 2012 08:25:32 GMT

Hello everyone ,

In my chart ı have two expressions one of them

count(IF(ISTEK_DURUM='Açık',ISTEK_DURUM)) (requests' statu : Open)

second expression

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açık'}>} ISTEK_ACISTARIHI2)

requests' statu open over 30 days

The problem is with second expression. above formula is working but business side want to see quantityof requests' statu open over 30 days for each week

my date dimension is :

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

Re: Expression about date

QSense — Mon, 19 Nov 2012 08:51:19 GMT

I wanna make below formula but is not working

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') - 30, 'DD.MM.YYYY

hh:mm:ss'))"},ISTEK_DURUM={'Açık'}>} ISTEK_ACISTARIHI2)

Re: Expression about date

QSense — Mon, 19 Nov 2012 08:59:28 GMT

In another words for each week

I wanna display both requests' statu : Open and requests' statu open over 30 days

Re: Expression about date

jagan — Mon, 19 Nov 2012 09:28:03 GMT

Hi,

Check whether date format is same in ISTEK_ACISTARIHI2 and

=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') - 30, 'DD.MM.YYYY

hh:mm:ss')

expression.

Hope this is the issue. Is time part exists in ISTEK_ACISTARIHI2 field.

Regards,

Jagan.

Re: Expression about date

QSense — Mon, 19 Nov 2012 09:44:16 GMT

date(date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') - 30, 'DD.MM.YYYY hh:mm:ss') format is same with ISTEK_ACISTARIHI2 only formula's time part is seen 00:00:00