Counting Values in a Bar chart

[#1]

Hi all,

My name is Jelger and i am just beginning with Qlikview to aid a customer of my companies scheduling application.

I have a question regarding combining imported formula outcomes in a Bar Chart.

for example:

I have a value per day: Monday 9:00 Tuesday 8:00 and Wednesday 7:30 (the values ar worked hours imported from a Scheduling application)

I'm trying to create a bar chart where per month/week/day the total number of worked hours are shown.

Can anyone point me in the right direction here? I’ve tried everything to count or sum the amount of worked hours but the values shown in the Bar Chart are not correct.

when I use =ONLY(expression) i get the right value in the bar chart but counting the different day values  up won't work.

Thanks in advance!

Regards,

Jelger

[MWiciok]

you can switch the number format in the propositions under number. There you can choose time as a format.

[#3]

Thanx Jeba,

strange, i openend the QVW i've uploaded earlier with no problem.

when i use only the expression (KDS_UrenGeerktDag_PLA) the chart is not doing anything at all.

[Anonymous]

pls try sum((KDS_UrenGeerktDag_PLA))

[#5]

It's getting a lot better. But still i can't manage to add up the vallues.

[#6]

thnx! i tried that and that's working but my values are still not correct...

[MWiciok]

Did you try to sum up selected values, so you can trigger the Problem better?

[Anonymous]

Which field you are using in the dimension?

It seems years.

Now can you manually select few items and see the numbers if it is matching.

If not send me the results

Because we need to check while doing the sum of hours.

[#9]

i'm using these fields in dimensions.

when i select a single value i doesn't match. Still i'm only getting right outcomes in the chart when i use ONLY(expression)

[MWiciok]

But the values are in time-format in QV?

[#11]

yes they are