Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

CROSSTABLE Vs CrossTab in script

Hi All,

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

Thanks in advance.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

8 Replies
swuehl
MVP
MVP

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?

qlikviewwizard
Master II
Master II
Author

Crosstab load

swuehl
MVP
MVP

The LOAD prefix is called CROSSTABLE, not CROSSTAB.

See

The Crosstable Load

qlikviewwizard
Master II
Master II
Author

Thank you swuehl

jagan
Luminary Alumni
Luminary Alumni

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.

qlikviewwizard
Master II
Master II
Author

Hi jagan

Thank you for the example.

rjyadav94
Contributor II
Contributor II

nice explaination thanks.

alis2063
Creator III
Creator III

Cross tab is a company