Discussion Board for collaboration related to QlikView App Development.
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 )
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
in graph you see only numbers of 30 days ago from today , In other week I can not see