topic Re: Set analysis for an expression in QlikView

Set analysis for an expression

QSense — Mon, 19 Nov 2012 12:05:34 GMT

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 )

QSense — Mon, 19 Nov 2012 12:48:51 GMT

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 — Mon, 19 Nov 2012 12:51:06 GMT

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