Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

qliekview
Contributor 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  )

Tags (1)
2 Replies
qliekview
Contributor II

Re: Set analysis for an expression

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

qliekview
Contributor II

Re: Set analysis for an expression

istek.png

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

Community Browser