topic Re: line chart in QlikView

line chart

Mon, 08 Jun 2015 04:48:29 GMT

I am trying to create line chart .

I am unable to do in qlikview but in tableau I am able to do it easily.

What features help in creating the line chart.

I am attaching screenshot from the tableau( the one i want) and qlikview( seems different )

What should I change so that my qlikview line chart looks tableau.

Re: line chart

PrashantSangle — Mon, 08 Jun 2015 09:35:58 GMT

Hi,

I think you have two dimension and one expression

just pramote Date_Of_stock Dimension.

Regards

Re: line chart

Mon, 08 Jun 2015 09:40:07 GMT

I did that

Attach is screenshot.If you see the chart is very different from the one in tableau.Tab chart is continuous .

Note You are right about dimension I have two dimension and one expression .

Re: line chart

PrashantSangle — Mon, 08 Jun 2015 09:46:03 GMT

Hi,

Go to Property->Sort->select Date_Of_Stock ascending

and then go to Property->Axes->select Primary Dimension Labels->select middle redio Button ->for / this way date representation or for | select third radio button

Regards

Re: line chart

Anonymous — Mon, 08 Jun 2015 09:47:17 GMT

Hey,

in Tableau you tage the AVG and in QlikView you take the Sum-Funktion, perhaps you have to take the Avg() Funktion in QlikView, too.

And you can Sort your Dimension Date_of_Stock in the right order.

Regards.

Re: line chart

r_wroblewski — Mon, 08 Jun 2015 09:49:06 GMT

Hi,

it looks like that the sort is different. Please check sort settings.

Regards,

Ronny

Re: line chart

Mon, 08 Jun 2015 09:55:18 GMT

I did all this.

In tab the line chart is continuous .

In qlikview I dont see that.

I mean qlikview I see continuous value only from feb ( few dates )

Re: line chart

awhitfield — Mon, 08 Jun 2015 09:55:52 GMT

Hi zeeshan4290,

are you able to Attach your app?

Andy

Re: line chart

Mon, 08 Jun 2015 09:56:58 GMT

No i know what u mean but it wont solve my problem

I want a line graph with each point on line graph corresponding to date and price .

Re: line chart

Mon, 08 Jun 2015 09:58:01 GMT

it little bit confidential and dont want to give data. sorry for that but i can give any other information by screenshot.

Re: line chart

PrashantSangle — Mon, 08 Jun 2015 09:59:28 GMT

Hi,

Do you have Close_Price on all dates???

If possible then post your app

Regards

Re: line chart

Mon, 08 Jun 2015 10:03:24 GMT

I have two dimension (stock_name and date).

Yes close_price is continuous.

Suppose the stock is listed in 1998.The value will be there from 1998 till date.

But not for sat sun or public holiday.

Sorry app is problem as it is confidential data.

Re: line chart

buzzy996 — Mon, 08 Jun 2015 10:17:39 GMT

PFA.

pls check and let me know instituted of period u can use ur code.

Re: line chart

Mon, 08 Jun 2015 10:18:25 GMT

i see the data in continuous in tab. the line chart is proper in tab .

in qlikview it not continuous.rather it shows few dates only.

attach is stock chart for apple

in qlikview i want same.

Apple Inc. Share Price Chart | AAPL - Yahoo!7 Finance

My chart is in same format.

price is on y-axis date is on x-axis(you see date is continuous )