Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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