Home > Software > QlikView
Interview Questions   Tutorials   Discussions   Programs   Videos   

QlikView - What is cross table?




1489
views
asked SRVMTrainings September 11, 2014 12:27 PM  

What is cross table?


           

3 Answers



 
answered By   0  

1)Cross table works like a pivot table in sqlserver , 2)by using this we can do the transformation in qlikview, 3)in this we can change the rows as a columns,and columns as a rows.

flag   
   add comment

 
answered By liyonardio   0  
Hi,

Are you referring to Cross table with cross tab.

Cross tables are table where facts are divided on the basis of dimension values.

for example we have sales for every month. then, if in our database we load sales amounts as a separated field for every month as

Product         Jan                    Feb                    Mar   etc

a                    100                    200                    300

 

So, basically we have 1 single fact as sales amount here, and jan-dec are dimension members of month dimension but we are creating different fields for every dimension member and treating them as different field.

Loading data this way, makes it difficult to properly aggregate the data over different dimensions and difficult to do analysis.

So, we convert this crosstable into a normal table.
using
crosstable (Month, Amount)
load
*

from a.qvd(qvd);

then we will get the same table as


Product     Month     Amount

a                    jan          100

a                    feb          200

a                    mar          300

I hope you understand now, what is crosstable. let me know if it solves your concern.

You can also go for online qlikview training and qlikview tutorials for further knowledge.
flag   
   add comment

 
answered By SRVMTrainings   0  
cross table is common type of table featuring a matrix of values between two orthogonal lists of header data. To turn cross table into straight table use cross table prefix Ex. Cross table(attribute field, data field[ in])(load/select statement)
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  3 people following this tag

  Question tags

qlikview × 1

Asked 3 years and 5 months ago ago
Number of Views -1489
Number of Answers -3
Last updated
3 years and 3 months ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert