Home > Software > QlikView
Interview Questions   Tutorials   Discussions   Programs   Videos   

QlikView - What is cross table?

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.

   add comment

answered By liyonardio   0  

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.
crosstable (Month, Amount)

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.
   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)
   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  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!