13 Replies Latest reply: Oct 2, 2012 11:49 AM by nelsontkx RSS

    Multiple fields in one bar chart

      Hi guys, I'm new to qlikview, so I hope you can help me out.

       

      Here is my objective. I got 4 fields with 200+ records in each fields, timing from 03:00 to 07:00hrs (Eg. PREPLAN_DT, DISPATCH_TIME)

       

      I want to create a bucket of 10mins interval. Eg. 03:00, 03:10, 03:20 . . . 06:50, 07:00

       

      So for each field, any records falls within the range will go to the bucket.

       

      My y-axis will show the count of each field.

       

      So 03:00 timing with have 4columns with different counts based on the fields and so on.

       

      I did alot of research on the net and found that I can create the bucket in dimension with something like

       

       

       

      =if([PREPLAN_DT] >= Timestamp#('03:00','hh:mm') and [PREPLAN_DT]<= Timestamp#('03:10','hh:mm'),'03:00',

       

      if([PREPLAN_DT] >= Timestamp#('03:10','hh:mm') and [PREPLAN_DT]<= Timestamp#('03:20','hh:mm'),'03:10',

       

      but when I put all 4 fields in 'expression' like Count(DISPATCH_TIME) and Count(PREPLAN_DT), all four columns display the same count.

       

      Any help is appreciated. Thanks in advanced.