Discussion board where members can get started with QlikView.
I want to create an chart wich displays data every 10 mins.
Currently i have an in_date_creation_hour_nr i want to transform this into
<hour>01:<minute>10 01:20 01:30 01:40 01:50 2:00 2:10 and so on.
i have also a table with minutes, in_date_creation_min_nr
Thanks in advance!
Go to Solution.
using yours dimension it can be:
you can use calculated dimension
Pari Pari wrote:using yours dimension it can be:=maketime(in_date_creation_hour_nr,floor(Minute(in_date_creation_min_nr)/10)*10)
Pari Pari wrote:
Works, thanks for the quick reply!
I want to do the same for week numbers, tried some combinations but not getting the wanted result yet.
what i want is :
YEAR - WEEKnumber
and so on
Looks nice i'm getting there.
Only thing i run into now is the sorting.
Its currently like:
2012-05 2012-03 2012-04 2012-19
Tried the following things:
But none of the above works.. any suggestions?
try to sort by expression: