topic Re: help with chart in QlikView

help with chart

hopkinsc — Tue, 14 Jan 2014 17:44:50 GMT

hi,

I am trying to plot prices on a line chart so i can see how the price changes over time.

It seems to work with no ref's selected or with a ref selected that only has 1 price attributed to it. for multiple ones it doesnt work.

I dont want to sum it expression as i want the individual prices plotted. can anyone help please?

I have added the frequency to the list box so you can see which have multiple lines.

sample attached

any help is welcomed

Re: help with chart

kiranmanoharrode — Tue, 14 Jan 2014 17:50:41 GMT

try this expression

=Sum(Amount)/Sum(Qty)

Re: help with chart

phaneendra_kunc — Tue, 14 Jan 2014 18:02:17 GMT

are you trying to plot "price" for each "Ref" for "Year & Week"?

Re: help with chart

Clever_Anjos — Tue, 14 Jan 2014 18:07:51 GMT

You have negative values in Quantity field, is it supposed to happen?

Re: help with chart

Clever_Anjos — Tue, 14 Jan 2014 18:09:00 GMT

Your Week field, should be sorted by time, correct?

Re: help with chart

hopkinsc — Tue, 14 Jan 2014 18:42:18 GMT

hi,

I am sorting by expression..

negatives are correct.

i am trying to plot price for product (i have not included product in the data, but the user has to select a product for the chart to populate, i have commented out the calculation condition in the chart)

Re: help with chart

Clever_Anjos — Tue, 14 Jan 2014 18:44:45 GMT

sum(Amount)/sum(Qty) should return what you want