topic Re: Compare Prices in QlikView

Compare Prices

Fri, 09 Mar 2012 09:13:41 GMT

Hi,

I’m trying to create a line chart that compares stock prices. I would like the prices to start at the same value. I’ve tried using the top function (Value / top(Value)), but it doesn’t seem to work. Any ideas?

My table looks like this:

Date	Stock	Value
01.01.2012	Stock A	100
01.01.2012	Stock B	10
01.01.2012	Stock C	300
02.01.2012	Stock A	102
02.01.2012	Stock B	9
02.01.2012	Stock C	310
03.01.2012	Stock A	105
03.01.2012	Stock B	8
03.01.2012	Stock C	320

Regards,

Tore

Compare Prices

CELAMBARASAN — Fri, 09 Mar 2012 09:16:56 GMT

Hi,

Use Max(Value).

Celambarasan

Re: Compare Prices

Fri, 09 Mar 2012 09:36:49 GMT

Do you mean Max(Value) / Top(Value)? I get the same result, see attached file.

Tore

Compare Prices

jagan — Fri, 09 Mar 2012 09:38:42 GMT

Hi,

Can you explain what the output would be.

Regards,

jagan.

Re: Compare Prices

Fri, 09 Mar 2012 09:49:04 GMT

Se the attached file. I've removed stock from dimension and used set analysis. I want the same output with stock as a dimension.

Re: Compare Prices

CELAMBARASAN — Fri, 09 Mar 2012 09:54:29 GMT

Hi,

Could you upload screen shot of that chart i cann't open your file because im using personal edition?

Celambarasan

Re: Compare Prices

Fri, 09 Mar 2012 09:57:29 GMT

See attached file

Re: Compare Prices

jagan — Fri, 09 Mar 2012 10:45:55 GMT

Hi,

Check the attached file for solution.

Regards,

Jagan.