Bar cahrt

[poonam_kulwal]

Hi All,

Below is the sample data. I need to plot a chart that gives information about

how much data transfer 1) different hours of a day by ReqID/Job

                                        2) Different days of week ReqID/Job

I thought of plotting ReqID on X axis and corresponding sum(Filesize) but my point of difficulty is I need analysis based on each day and for that day each hour. ReqId is on highest hierarchy. Also want to see which job is transmitting maximum bytes.

How to approach this problem?

[Anonymous]

Create a master calendar with grain as hours, create a group dimension (Creating Cycle and Drill Groups - YouTube) with day and hours and then use sum(Filesize) as expression, then use color coding to highlight the bar with the maximum value of sum(Filesize).Highlight Min & Max values on Line Chart - QlikView Blog, QlikView Videos and Tips at QlikShare

[Anil_Babu_Samineni]

Check this