NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

[#1]

I have excel file in format

APR-2013	japan	india	france
reported cases	1009	100456778	34000
cases not filed	545	242342134	24234
total prison	3445	234333	2344

likewise I have data for other months too for a particular year

now I need to show this data in qlikview with respect to country and month_year

I have used crosstable here

crosstable(country,data)

and it gives me data with respect to country,
now how I can get month_year

help me to get the month here

[venkatg6759]

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

Check the link if that helps

[#3]

its the same thing wat I have already done....I already created crosstable...and its giving me data for country

I need the corresponding month_year

[venkatg6759]

check the attached example

[#5]

don't have licenced version cant open that file..if u can guide ...how  it can be done ...I will be thankful to u

[venkatg6759]

I think you can check this 

Loading Cross Tables

[rogerioqv]

Shrivas...

See if that helps you.

[venkatg6759]

From Rogerio ,since you can't open .Try the script

REPORT_TMP:

LOAD [total prision],

     [reported cases],

     [cases not filed],

     [APR-2013] as Country,

     [APR-2013]

FROM

CROSS_TABLE.xls

(biff, embedded labels, table is Sheet1$, filters(

Rotate(right)

));

NoConcatenate

REPORT:

LOAD

     [total prision],

     [reported cases],

     [cases not filed],

     Country,

     MID(FieldName(5,'REPORT_TMP'),1,3) AS MONTH,

     MID(FieldName(5,'REPORT_TMP'),5,4) AS YEAR

Resident REPORT_TMP;

DROP TABLE REPORT_TMP;

[rogerioqv]

Shrivas...

If you can not open the file, use the following script:

REPORT_TMP:

LOAD [total prision],

     [reported cases],

     [cases not filed],

     [APR-2013] as Country,

     [APR-2013]

FROM

CROSS_TABLE.xls

(biff, embedded labels, table is Sheet1$, filters(

Rotate(right)

));

NoConcatenate

REPORT:

LOAD

     [total prision],

     [reported cases],

     [cases not filed],

     Country,

     MID(FieldName(5,'REPORT_TMP'),1,3) AS MONTH,

     MID(FieldName(5,'REPORT_TMP'),5,4) AS YEAR

Resident REPORT_TMP;

DROP TABLE REPORT_TMP;