topic Re: Custom Tabl chart in QlikView

Custom Tabl chart

alec1982 — Fri, 11 Jan 2013 20:30:31 GMT

Hi Guys,

I have a data source that looks like:

State Year HC

NY 2013 2000

NY 2014 1500

NY 2015 1800

Atlanta 2013 4000

Atlanta 2014 1500

Atlanta 2015 2000

How can I make a table chart to show as follow:

State 2013 2014 2015

NY 2000 1500 1800

Atlanta 4000 1500 2000

I would appreciate it if we can do that in the script as i want to add more calculated fields such as Varience between years and percentage.

Thxs,

Alec

Re: Custom Tabl chart

shree909 — Fri, 11 Jan 2013 20:33:28 GMT

hi use the cross table function when loading the data from the datasource...

Re: Custom Tabl chart

alec1982 — Fri, 11 Jan 2013 20:37:14 GMT

I know that can be done through a Generic load but not sure how to do that1

Thxs

Re: Custom Tabl chart

alec1982 — Fri, 11 Jan 2013 20:39:13 GMT

Hi,

The cross table doesn't work here! what I am trying to do is the oposite of the cross table

Re: Custom Tabl chart

alec1982 — Fri, 11 Jan 2013 20:42:52 GMT

Hi,

I figured it out

Table2:

Generic Load *

Resident table1;

Re: Custom Tabl chart

MayilVahanan — Fri, 11 Jan 2013 20:43:39 GMT

Generic

Load * Inline

[

State,Year,HC

NY, 2013,2000

NY, 2014,1500

NY, 2015,1800

Atlanta,2013,4000

Atlanta,2014,1500

Atlanta,2015,2000

];

Re: Custom Tabl chart

nagaiank — Fri, 11 Jan 2013 20:44:54 GMT

You may load data (as the data source has it) in a table with three fields (State, Year, and HC).

You can display the data as desired by you using a pivot table chart with State and Year as dimensions. The year dimension can be made to appear on the top by drag and drop on the pivot table.

With the same table structure, you can define other calculated fields (variance, percentage, etc.) using set analysis expressions.