expression historic data

QSense — Thu, 22 Nov 2012 11:55:46 GMT

Hello ,

I would like to show historic data in chart

Let me explain in example;

In my chart I have one dimension and two expressions

My dimension is calculated and its formaula is date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')

One of my expression is that it considers two fields (ISTEK_DURUM)(this is request statu such as open,closed) and (ISTEK_ACISTARIHI2)(this is creation date of request)

With this expression I want to see request that ISTEK_DURUM=''Açık' and creation time older than 30 days before (my dimension displays each start day of week)

I can calculate the expression based on today with this formula

=count((if(date(today())-date(ISTEK_ACISTARIHI2,'DD.MM.YYYY')>=30 and ISTEK_DURUM='Açık',1)))

but for each week ı can not calculate it means based on week ,shown in graph, I cannot get data older than days before that week

what ı want is that

its not working count((if(date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')-date(ISTEK_ACISTARIHI2,'DD.MM.YYYY')>=30 and ISTEK_DURUM='Açık',1)))

You can see my qw in turuncu hat istekler tab

topic expression historic data in QlikView

expression historic data