Discussion Board for collaboration on QlikView Scripting.
from the sample data below ,
i created this bar chart :
and now i want to know if it's possible to add a fifth (horizontal) bar to the chart (same chart) for the average ( Month : feb )
Will this do?
i know this method but i want to add a horizontal bar
There is no option in bar chart. You can use the reference line
And increase the weight as per attached file
Chk it out
LOAD * INLINE [
mon, Prod, Stock
Feb, A, 10
Feb, B, 20
Feb, C, 30
Feb, D, 40
Mar, A, 20
Mar, B, 39
Mar, C, 34
Mar, D, 23
load mon, 'Avg' as Prod, avg(Stock) as Stock
Group by mon;
Like below... Please confirm... i will upload the trick...
Also, confirm which edition you are using ?
i.e. Licensed or Personal...
Please mark it as correct answer if the solution provided is suitable for you.
is there any method to get the same result using chart expression not in the load script ?
thanks for your help but the results seems to be wrong !
What could be the result?
Kindly let me know, I will check and confirm back...