topic Re: Cross table in QlikView

Cross table

Anonymous — Tue, 26 Sep 2017 05:33:41 GMT

Hello Everyone,

How to apply cross table function in the below data?

Regards

kulwant

Re: Cross table

Anil_Babu_Samineni — Tue, 26 Sep 2017 05:43:53 GMT

Instead Cross table you can apply transpose while loading.. Can you share excel file and expected result

Re: Cross table

Anonymous — Tue, 26 Sep 2017 05:55:36 GMT

attached

Re: Cross table

its_anandrjs — Tue, 26 Sep 2017 06:03:48 GMT

Hi,

Load your data this way

tmpSource:

CrossTable(Dates, Data, 2)

LOAD F1,

F2,

[01/11],

[02/11],

[03/11]

FROM

Data1.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD

F1 as Area,

F2 as Range,

Dates,

Data

Resident tmpSource Where Data <> '%';

DROP Table tmpSource;

OutPut:-

Re: Cross table

Anonymous — Tue, 26 Sep 2017 06:11:53 GMT

thanks

Re: Cross table

Anil_Babu_Samineni — Tue, 26 Sep 2017 06:13:07 GMT

Here we go

Re: Cross table

Anonymous — Tue, 26 Sep 2017 06:39:31 GMT

Crosstable can be done directly while loading data only.

Click Table Files -> Next-> Next-> Under Prefixes select -> Crosstable-> Select Qualifier fields-> Atrribute fields (Which you want to make it straight) -> Data field

CrossTable(Account, Data)

LOAD MonthlyRegionKey,

Account,

ExpenseActual,

ExpenseBudget

FROM ....

Now table will be of 3 columns

MonthlyRegionKey | Account | Data

Account

Exp Actual

Exp Budget