topic Re: CROSSTABLE Vs CrossTab in script in QlikView

CROSSTABLE Vs CrossTab in script

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

Could you please explain and give an example for CROSSTABLE Vs CrossTab in script.

Thanks in advance.

Re: CROSSTABLE Vs CrossTab in script

swuehl — Sun, 19 Jul 2015 14:53:47 GMT

What do you mean with 'CrossTab'? Can you tell the context you have found this term?

I assume you think it's kind of a function name or statement?

Re: CROSSTABLE Vs CrossTab in script

qlikviewwizard — Sun, 19 Jul 2015 15:12:11 GMT

Crosstab load

Re: CROSSTABLE Vs CrossTab in script

swuehl — Sun, 19 Jul 2015 15:24:22 GMT

The LOAD prefix is called CROSSTABLE, not CROSSTAB.

See

The Crosstable Load

Re: CROSSTABLE Vs CrossTab in script

qlikviewwizard — Mon, 20 Jul 2015 00:25:56 GMT

Thank you swuehl

Re: CROSSTABLE Vs CrossTab in script

jagan — Mon, 20 Jul 2015 00:29:37 GMT

HI,

I never heard the CrossTab may be you are referring the CrossTable(), there is no keyword or function with name CrossTab.

When you want to unpivot the values then you have to use the CrossTable.

For example

Product, Jan-2015, Feb-2015, Mar-2015, Apr-2015

1,100, 120, 120, 125

2, 120, 90, 110, 115

The above is not suitable for reporting purposes so we need to transform this data to report suitable format, for this we need to use the CrossTable() like below

CrossTable(Month, Sales)

LOAD

FROM Sales;

The above script converts the data into below format

Product, Month, Sales

1, Jan-2015, 100

1, Feb-2015, 120

1, Mar-2015, 120

Hope this helps you.

Regards,

Jagan.

Re: CROSSTABLE Vs CrossTab in script

qlikviewwizard — Mon, 20 Jul 2015 04:40:10 GMT

Hi jagan

Thank you for the example.

Re: CROSSTABLE Vs CrossTab in script

rjyadav94 — Fri, 28 Dec 2018 02:19:50 GMT

nice explaination thanks.

Re: CROSSTABLE Vs CrossTab in script

alis2063 — Tue, 01 Jan 2019 09:38:53 GMT

Cross tab is a company