topic Re: Crosstable, Crossjoin Script in QlikView

Crosstable, Crossjoin Script

Fri, 14 Oct 2016 14:35:34 GMT

Hello,

I am trying to write a script which will combine data from multiple inputs, calculate columns and load a final table.

Please refer to the attached excel and give your suggestions.

Thanks.

el_aprendiz111 — Sat, 15 Oct 2016 12:53:51 GMT

hI,

Directory;

CrossTable(Days, Data, 2)

INPUT_1:

LOAD * FROM

[..\..\..\..\..\..\..\Desktop\web_Qlik\Crosstable,Crossjoin.xlsx]

(ooxml, embedded labels, table is Input1);

INPUT_2:

LOAD * FROM

[..\..\..\..\..\..\..\Desktop\web_Qlik\Crosstable,Crossjoin.xlsx]

(ooxml, embedded labels, table is Input2);

Right Join

LOAD * Resident INPUT_1 Where Data>0; DROP Table INPUT_1;

Mon, 17 Oct 2016 10:58:17 GMT

Thanks for your suggestion.

The solution does not restrict the output to pick only the November's data. Can we use any other column to identify the month as November?