Multiple fields in one bar chart

[#1]

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.

[#2]

Hi Stefan,

I couldnt open the file as I'm using personal edition. Do you mind post screenshot or cut/paste the solution here.

Very much appreciated.

[#3]

Hi Stefan,

Don't need to post the solution. I manage to figure out myself the rest of it. 

Thanks alot for your help. Really save my life.

I have one last problem. Open the image and notice 06:00 suddenly jump to 06:20. Anyway I could also display 06:10 even if it is empty?

[kruppas78]

You can show everyempty timeperiod.

Go to Chart Properties -> presentation -> and disable "supress Zero-Values"

If You dont want to see the Values above 06:00 you can use a WHERE clause.

[#5]

It doesn't work, I also tried unchecked 'Suppress Missing' and 'Zero on bars' in Presentation, also unchecked 'Suppressed when value is null' in dimension. And I also checked 'Show all values' in dimension