Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

1 Solution

Accepted Solutions
Highlighted
Not applicable


I found the solution.

problem was the format of the formulas i imported from our schedulling application.

many thanks for the help!

View solution in original post

21 Replies
Highlighted
Specialist
Specialist

Can you share your app?

Highlighted
Not applicable

Hi Jebamalai,

Do you mean my whole QVD file?

(i'm sorry, i'm really new to this )

Regards,

Jelger

Highlighted
Specialist
Specialist

Hi Jelger,

No,your QVW file with some dummy data is enough.

Regards

Jeba

Highlighted
Not applicable

Hi Jeba,

Thanks!

the Bar chart i mean is on the tab 'Dashboard'.

below the Bar Chart 'Uren per Periode' you find a table with te imported formula outcomes. The values from 'Realisatie Planning' for instance i want to count them per day, week, month.

Regards,

Jelger

Highlighted
Specialist
Specialist

For some reasons,I am not able to open the qvw file you sent

Can you paste the screenshot with the expression you tried and send me

Highlighted
Not applicable

i hope this gives you the needed information.

Highlighted
Creator
Creator

View attached file.

I created a group with Month, Weekday and actual day. With this you can Switch the time-view in your Chart.

Highlighted
Not applicable

Thanks Matthias!

I've created a group with date(KEY) weekday and month, that works a lot better. butt still the outcomes in hours are not correct.

I think i'm not counting the values per day the right way...

Highlighted
Specialist
Specialist

Can you remove the Rangesum and try?

Also change the format to HH:MM

I can check if I see your app,but unfortunately its not working