Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator 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

hello,

Try this

load *

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

QSense
Creator II
Creator II
Author

Thanks for reply

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

Not applicable

Try

date(num(AÇILIS_TARIHI)-30)

QSense
Creator II
Creator II
Author

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