topic Re: date equals todate() in QlikView

date equals todate()

Tue, 04 Oct 2011 12:22:48 GMT

Hi Qlik gurus!

I'm trying to implement quit simple calculations, but due to lack of experience have hit the stumbling block with them. The task for me is to calculate
count(Event_ID) = today
What I've done so far: i tried to use the following syntax: if(floor(Start_Timestamp)=today(),count(Event_ID),0), but it returns 0 everywhere which is not correct,
also I tried to use variables on a Load script level, but got the same - 0 everywhere. What I'm missing and what's wrong with my syntax?

Many thanks in advance.

Re: date equals todate()

lironbaram — Tue, 04 Oct 2011 13:18:50 GMT

hei

i changed a little bit your expression ,

i also changed the reference date to today()-180 as you do not have records for today so you'll get 0 values

hope its helps you

Re: date equals todate()

Wed, 05 Oct 2011 13:28:45 GMT

Ok, yes that was my fault, I uploaded incorrect data, also I changed the value from today() to today(0).. it' s quite strange that today() can return multiple values based on a number in the brackets.

I was able to figure out how to calculate the max value per year based on a month:
sum({<Year={$(=($(vGads)))}, Month={$(=($(vMonth2)))}>} Numval) where vGads and vMonth both are variables.

But how to calculate the max value based on the current month? In this particular case the formula must return 264... I'm out of ideas how to implement this.