Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable
Check the link if that helps
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
check the attached example
don't have licenced version cant open that file..if u can guide ...how it can be done ...I will be thankful to u
I think you can check this
Shrivas...
See if that helps you.
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;
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;