understanding cross tables

[Anonymous]

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

[Kushal_Chawda]

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

[qlikviewwizard]

Hi,

Check this table.

CrossTable Load in Qlikview-Source

[ecolomer]

See this:

Cross Table

Handling dates and cross table

[Anonymous]

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/>