Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting Values in a Bar chart

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

21 Replies
MWiciok
Creator
Creator

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

Not applicable
Author

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.

jebamalai
Specialist
Specialist

pls try sum((KDS_UrenGeerktDag_PLA))

Not applicable
Author

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

Not applicable
Author

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

MWiciok
Creator
Creator

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

jebamalai
Specialist
Specialist

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.

Not applicable
Author

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
Creator
Creator

But the values are in time-format in QV?

Not applicable
Author

yes they are