topic Re: understanding cross tables in QlikView

understanding cross tables

Anonymous — Sun, 20 Sep 2015 05:09:07 GMT

Hi,

I am trying to use a crosstable to load the following data from excel:-

I need to load team id, id and targets that are in each month.

How can I achieve this? Any help appreciated.

Laura

Re: understanding cross tables

Kushal_Chawda — Sun, 20 Sep 2015 05:25:54 GMT

crosstable(Months, Target,2)

load team_id,

id,

1/07/2015,

1/08/2015,

1/09/2015,

1/10/2015,

1/11/2015

From Table

Re: understanding cross tables

qlikviewwizard — Sun, 20 Sep 2015 05:57:31 GMT

Hi,

Check this table.

CrossTable Load in Qlikview-Source

Re: understanding cross tables

ecolomer — Sun, 20 Sep 2015 06:21:04 GMT

See this:

Cross Table

Handling dates and cross table

Re: understanding cross tables

Anonymous — Sun, 20 Sep 2015 23:33:15 GMT

Thank-you for your help

Laura Castagna

Business Systems and Process Analyst, NSW Business Chamber

140 Arthur Street North Sydney NSW 2060

Tel: 02 9458 7804 | Mob: 0429 486 934 | Web: www.nswbusinesschamber.com.au<http://www.nswbusinesschamber.com.au>

Twitter<http://www.twitter.com/nswbc> | Facebook<https://www.facebook.com/NSWBusinessChamber> | LinkedIn<http://www.linkedin.com/company/388425?trk=saber_s000001e_1000> | YouTube<http://www.youtube.com/nswbctv>

<http://www.nswbusinesschamber.com.au/>

Proud supporter of:

<http://acci.headsup.org.au/>