topic Re: Working with histograms in QlikView

Working with histograms

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need some help displaying datas with histograms; attatched you can find the .qvw file.

This is the dataset: each person (NAME) does different types of activities (TYPE) in a defined time (DATETIME); each person works 8 hours per day, so the sum of DATETIME displays what they have done. I would like to add in the histogram a dimension which displays the difference between 8 hours and DATETIME, so the time they have spent doing nothing.

In other words, next the red portion of graph i would like to have another color which displays the "free time".

Is it possibile to do this in frontend?

Thank you in advance.

Re: Working with histograms

dmac1971 — Tue, 06 Mar 2018 14:19:00 GMT

Hi Andrea. This should give you the output you are looking for. I've added a variable to store the length of the working day, and added charts to show breakdown by time and %. Hopefully this is what you were looking for.

Re: Working with histograms

Anonymous — Tue, 06 Mar 2018 16:06:25 GMT

This is exactly what i needed! Thank you