Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

I have excel file in format

APR-2013japanindiafrance
reported cases100910045677834000
cases not filed54524234213424234
total prison34452343332344

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

8 Replies
venkatg6759
Contributor III

Re: NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

Not applicable

Re: NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

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
Contributor III

Re: Re: NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

check the attached example

Not applicable

Re: NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

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
Contributor III

Re: NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

I think you can check this 

Loading Cross Tables

rogerioqv
Contributor II

Re: Re: NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

Shrivas...

See if that helps you.

venkatg6759
Contributor III

Re: NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

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
Contributor II

Re: Re: NEED HELP IN MANAGING EXCEL DATA IN QLIKVIEW

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;

Community Browser