Cross Table

priyarane — Wed, 22 Apr 2015 09:14:29 GMT

Hi Experts,

I have requirement to build and attached Requirement as Req and Data as source.

My requirement is already been done by Petter Skjolden. - FRB Report(Developed One). But I am not able to understand script, how he has done with the help of cross table and others.

Script:

[DataSheet]:

CrossTable(AP, Data, 1)
LOAD
Item*10 AS Item,
date AS Actual,
[PQ 1],
[PQ 2],
[PQ 3],
[PQ 4],
[PQ 5],
[PQ 6],
[PQ 7],
[PQ 8],
[PQ 9]
FROM
Souce.xlsx
(ooxml, embedded labels, header is 1 lines, table is Sheet1);

[RowHeaders]:
LOAD
RecNo() AS RowNo,
@1 * 10 AS Item,
If( IsNum(@1) , Peek(ItemTxt) , @1) AS ItemTxt,
@2 AS [Item Text]
FROM
Souce.xlsx
(ooxml, no labels, table is Sheet1, filters(
ColXtr(1, RowCnd(CellValue, 1, StrCnd(shorter, 0)), 0)
));

so My question is, what is: CrossTable(AP, Data, 1)
and @1 * 10 AS Item,
If( IsNum(@1) , Peek(ItemTxt) , @1) AS ItemTxt,
@2 AS [Item Text]

Please check my source and how he built as per requirement.

I have many reports like that to build, If I can understand better then I will create reports quickly.

Thank you.

topic Cross Table in QlikView

Cross Table