Rate function alternatives

Mon, 26 Sep 2011 08:05:43 GMT

Hello,

Would be very grateful if somebody helps me solving following task, as my knowledge isnt enough and for the past week i am out of ideas how to slove it.

I have table with columns:

ID; Name and timestamp:

I need to rate timestamps inside Name dimensions, so the first timestamp is always 0 (1 is ok also).

Example:

ID Name Timestamp Rating

bosk1nxxx bosk1n 40745.534 0

bosk1nxxx bosk1n 40747.534 1

nikoxxx niko 40747.534 0

nikoxxx niko 40748.834 1

nikoxxx niko 40749.834 2
etc.

I've tried different options like with rank() function, RANK( TOTAL <Name> Timestamp), above(), before() functions. Combinations of peek, previous functions. But couldnt solve this task. I am kind of despered, cause i know the answer is somewhere close, but i cannot solve it. Could somebody help?

Attaching table just in case.

Re: Rate function alternatives

lironbaram — Mon, 26 Sep 2011 11:01:00 GMT

hei

attach is an example doing it in the load script

hope its helps you

Re: Rate function alternatives

Mon, 26 Sep 2011 12:04:45 GMT

Thanks a lot Liron! Looks like that's exactly what I was looking for. You've ended my tortures

And thanks for learning me new useful function numsum()

topic Re: Rate function alternatives in QlikView

Rate function alternatives

Re: Rate function alternatives

Re: Rate function alternatives