Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sayadutt
Creator
Creator

Help in bar chart

Hi Team,

I am new to qlikview. I have a requirement where i have 4 columns as below

   

Created to ApprovedApproved To Master-StagingMaster-Staging to MasterTotal Time
0.043.820.754.60
14.070.004.0918.17
1.770.514.296.58
6.960.004.5611.52
0.250.004.584.82
2.130.004.626.75
0.790.004.635.42
9.610.074.6414.32
10.780.004.6915.47
0.700.215.045.95
14.681.435.2321.34

I need to produce the graph as below:

Can you please help me here:

these are the AVERAGE of the individual columns

Untitled.png

1 Solution

Accepted Solutions
adamdavi3s
Master
Master

I wouldn't use anything, I don't think you will need one?

If you do then use valuelist, will try it out in a sec

View solution in original post

5 Replies
adamdavi3s
Master
Master

just use the formula avg(columnname) as your expression for each column

sayadutt
Creator
Creator
Author

Thanks Adam.

What should I use in Dimension?

adamdavi3s
Master
Master

I wouldn't use anything, I don't think you will need one?

If you do then use valuelist, will try it out in a sec

Not applicable

You can leave it empty.

adamdavi3s
Master
Master

Valuelist means you can get some nice simple labels which I prefer, bit more of a fiddly setup so depends what you want really!

Capture.PNG