Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QSense
Contributor II

if condition satisfy two conditions

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

4 Replies
Not applicable

Re: if condition satisfy two conditions

hello,

Try this

load *

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

QSense
Contributor II

Re: if condition satisfy two conditions

Thanks for reply

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

Not applicable

Re: if condition satisfy two conditions

Try

date(num(AÇILIS_TARIHI)-30)

QSense
Contributor II

Re: if condition satisfy two conditions

=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)

Community Browser