topic Re: Bar cahrt in QlikView

Bar cahrt

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

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?

Re: Bar cahrt

Anonymous — Wed, 03 May 2017 04:45:16 GMT

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

Re: Bar cahrt

Anil_Babu_Samineni — Wed, 03 May 2017 04:47:11 GMT

Check this