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

Set analysis for an expression

Hello

I wanna write a set analysis for count request like

requests' statu = "Acik"

and its statu 'Acik' older than 30 days ago my date field ISTEK_ACISTARIHI2  format  is "DD.MM.YYYY hh:mm:ss"

but for each week I would like to see   total count of request's statu 'Acik' and older than 30 days ago

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

for example 14.05.2012 total count  (statu 'Acik' older than 30 days ago  )

21.05.2012 total count  (statu 'Acik' older than 30 days ago  )

2 Replies
QSense
Creator II
Creator II
Author

I have an expression but it does not stasfy my needs

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

Above expression calulates (statu 'Acik' older than 30 days ago  ) based on today but I would like to see for each week's data not only based on today

QSense
Creator II
Creator II
Author

istek.png

in graph you see only numbers of 30 days ago from today , In other week I can not see