topic Re: if condition satisfy two conditions in QlikView

if condition satisfy two conditions

QSense — Tue, 20 Nov 2012 08:42:20 GMT

Hello

I have to fields ISTEK_DURUM and ISTEK_ACILISTARIHI

ı have get data where ISTEK_DURUM='Açık' and ISTEK AÇILIS_TARIHI older than 30 days ago

Tue, 20 Nov 2012 09:28:03 GMT

hello,

Try this

load *

resident TABLE_NAME where wildmatch(ISTEK_DURUM,'Açık')>0 and AÇILIS_TARIHI<date(today()-30);

QSense — Tue, 20 Nov 2012 09:30:52 GMT

Thanks for reply

not today -30 I want to get 30 days older than AÇILIS_TARIHI

Tue, 20 Nov 2012 09:37:49 GMT

Try

date(num(AÇILIS_TARIHI)-30)

QSense — Tue, 20 Nov 2012 09:43:02 GMT

=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') my dimension date in chart

my dimension - 30 all ı want

Below expression calculates from today not ISTEK_ACISTARIHI2

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