topic Re: line chart presentation in QlikView

line chart presentation

alec1982 — Fri, 31 Jul 2015 20:19:50 GMT

hi all,

I am looking for best practices of how to present a value of an item that has a price changing every day on a line chart.

for example if we have two products( Laptops, PCS) and the prices on both change everyday and we have the historical prices per date..

What is the best way to present the prices per date on aline chart knowing that I want to see both products on the chart?

Thxs,

Alec

qumniusomnius — Fri, 31 Jul 2015 20:43:39 GMT

you can make line chart with 2 dimensions, first one is Date, second one Product

in expression just write sum(Price)

it will show separate lines for each product.

If you want to show just specific products you can make line chart with just Date as dimension,

and write multiple expressions like this:

sum({<Product = {'Laptops'} >} Price)

alec1982 — Fri, 31 Jul 2015 20:51:15 GMT

the problem is the products are not same all the time...

antoniotiman — Fri, 31 Jul 2015 21:00:48 GMT

Like this

alec1982 — Fri, 31 Jul 2015 21:04:25 GMT

yes but how to do it when i have products that have various name

antoniotiman — Fri, 31 Jul 2015 21:10:11 GMT

See Attachment.

You can add some Products in script.

Regards,

Antonio

alec1982 — Sat, 01 Aug 2015 02:56:15 GMT

is there anyway I can show the dates at the bottom like this

Day

Month

year

for example

Jun

2015

antoniotiman — Sat, 01 Aug 2015 06:31:36 GMT

See attachment