Discussion board where members can get started with QlikView.
Could you please explain and give an example for CROSSTABLE Vs CrossTab in script.
Thanks in advance.
Go to Solution.
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.
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
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.
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?
The LOAD prefix is called CROSSTABLE, not CROSSTAB.
The Crosstable Load
Thank you swuehl
Thank you for the example.
nice explaination thanks.
Cross tab is a company