topic Display Individual Dimension and Average on same graph in QlikView

Display Individual Dimension and Average on same graph

Tue, 08 Feb 2011 11:22:45 GMT

http://community.qlik.com/forums/t/19723.aspx

Hello, how would you represent those data on the same graph, both:

- on X axe: time (here year)

- on Y: several curves showing

- the sales for each customer

- the average for each year

I am trying to find a solution on this kind of topic without success

Thanks you for your help,

Bruno

Display Individual Dimension and Average on same graph

Anonymous — Tue, 08 Feb 2011 11:43:11 GMT

This you can try : Copy and past the expression and adjust the new expression in something like this:

(Sum (Sales) /Count (Distinct Year))

Display Individual Dimension and Average on same graph

Tue, 08 Feb 2011 13:14:30 GMT

Hello, thanks for your reply but I am still having an issue with the "dimension" i need to use in the graph.

What should be the right parameter to use in "dimension" - i guess Year ? what's about customer which is my 2nd axe of display & analysis for the average value ?

Thanks

Bruno