topic Re: expression based on a Date Field in QlikView

expression based on a Date Field

QSense — Tue, 20 Nov 2012 09:28:51 GMT

Hello ,

My below expression is based on today -30

but I want to based it on my dimension =date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')

İn shortly my dimension - 30 all ı want

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

Re: expression based on a Date Field

Tue, 20 Nov 2012 09:46:29 GMT

if ur field is timestamp format then use

timestamp(timestamp#(urdimension)-30)

it is first convert timestamp filed into numbers and substract with 30 then

it convert it in to timestamp format

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=timestamp(timestamp#(urdimension)-30), 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açik'}>} ISTEK_ACISTARIHI2)

Re: expression based on a Date Field

QSense — Tue, 20 Nov 2012 09:50:58 GMT

Unfortunately it didnt work

Re: expression based on a Date Field

Tue, 20 Nov 2012 09:56:48 GMT

what is this

ISTEK_ACISTARIHI2 format give some values for this

Re: expression based on a Date Field

QSense — Tue, 20 Nov 2012 09:59:58 GMT

Exactly What do you mean?

Re: expression based on a Date Field

Tue, 20 Nov 2012 10:22:03 GMT

it has another solution

i create one variable with expr like

vdays

=Timestamp(Timestamp#(PERIOD_END_DATE)-30)

and in expression

Sum({<PERIOD_END_DATE={">=$(vdays)"}>}CR_AMOUNT)

it works for me

for u use the below expr

Sum({<ISTEK_ACISTARIHI2={">=$(vdays)"},ISTEK_DURUM={'Açik'}>}metric)

Re: expression based on a Date Field

QSense — Tue, 20 Nov 2012 11:06:45 GMT

Where did you create variable in script side or in where

Re: expression based on a Date Field

QSense — Tue, 20 Nov 2012 11:24:29 GMT

I created variable but it does not satisfy date condition

for example 01.01.2012 selected ıt must get 30 days before data from this date but

it does not work in this way

Re: expression based on a Date Field

Tue, 20 Nov 2012 12:42:52 GMT

use date() insted of timestamp()

date#() instead of timestamp#()

in th above exp

create variable in settings-variable overview

vdays

=date(date#(PERIOD_END_DATE)-30)

Sum({<ISTEK_ACISTARIHI2={">=$(vdays)"},ISTEK_DURUM={'Açik'}>}metric)

ur field in date format

my exp in timestamp format

it work for me