topic charts - excel and qlikview in QlikView

charts - excel and qlikview

Fri, 12 Feb 2016 11:01:22 GMT

Hi,

Can people please clarify and confirm that you can't replicate charts in Qlikview.

So here is standard setup of data in excel to create a line/bar chart:

The chart I'm looking for is:

However, this same format in Qlikview doesn't work and so the chart above can't be replicated. I have to transpose the data like so then it works...can people please confirm is this normal?:

Chris

Re: charts - excel and qlikview

MayilVahanan — Fri, 12 Feb 2016 11:04:32 GMT

Try like this

Properties -> Presentation -> Check "Horizontal" checkbox.

Re: charts - excel and qlikview

MayilVahanan — Fri, 12 Feb 2016 11:05:56 GMT

Hope you are asking in Straight table and with 5 expression..

Re: charts - excel and qlikview

kaushiknsolanki — Fri, 12 Feb 2016 11:08:07 GMT

Hi,

This is normal. You don't need to worry about changing the excel and transpose the data. QlikView has functions which will help you to do that automatically.

Regards,

Kaushik Solanki

Re: charts - excel and qlikview

luciancotea — Fri, 12 Feb 2016 11:14:23 GMT

See Crosstable in help in order to import data easily into QlikView from your format.

The resulted table in QlikView should look like:

RefName	Month	Value
Ref1	Ian	1
Ref2	Ian	2
Ref1	Feb	3
Ref2	Feb	4

Re: charts - excel and qlikview

awhitfield — Fri, 12 Feb 2016 11:23:31 GMT

Hi Chris,

1. Which chart are you struggling with?

2. What format is you load data in?

Andy

Re: charts - excel and qlikview

Fri, 12 Feb 2016 11:29:29 GMT

See attached app. I have put data into a straight table and added each month as an expression - is this correct?

However, its the chart I want to work. I want a line chart fr each Indicator: Ref 1, Ref 2 etc.

Re: charts - excel and qlikview

kaushiknsolanki — Fri, 12 Feb 2016 11:35:34 GMT

Hi Chris,

I have manipulated the data and done the chart which you are looking for.

Have a look at the attached example.

Regards,

Kaushik Solanki

Re: charts - excel and qlikview

MayilVahanan — Fri, 12 Feb 2016 11:38:55 GMT

PFA

Re: charts - excel and qlikview

Fri, 12 Feb 2016 11:43:51 GMT

Hi,

Great, but I need to split the charts up - chart for ref 1, one for ref 2 etc.

This app will be used as a dashboard.

Re: charts - excel and qlikview

awhitfield — Fri, 12 Feb 2016 11:44:22 GMT

Hi Chris,

can you upload the .xls data source too?

Andy

Re: charts - excel and qlikview

kaushiknsolanki — Fri, 12 Feb 2016 11:48:58 GMT

Hi,

Just create copy of the charts and add following expression in chat.

Sum({<Indicator = {"Ref 1"}>}Value)

Sum({<Indicator = {"Ref 2"}>}Value)......

Regards,

Kaushik Solanki