What is a cross table? How is it different from transposing a table using a Rotate function?
Answer / Joginder
A "cross table" in QlikView is a chart that displays data as rows and columns, with the intersection of each row and column showing the associated value. Cross tables are often used for analyzing relationships between multiple dimensions or categories.nnTransposing a table using the Rotate function in QlikView rearranges the rows and columns so that the original columns become rows and vice versa. This can be useful when you want to visualize data differently, but it does not create a true cross table as the row and column headers may overlap.nnIn contrast, a cross table explicitly shows the intersection of multiple dimensions, making it easier to understand complex relationships between them.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you understand by Rangesum() function? How is it different from the Sum() function?
Can we load web files into qlikview? If yes, how?
What do you understand by qvd files?
Difference between star schema and snow flake schema?
What is mini chart?
What can you do from a box plot wizard?
Explain Gauge charts?
How many dimensions can be used in bar chart?
Explain mini chart?.what do you mean by sub reports and how we can create them?
What is a mapping table?
What is the difference between QVD, QVW and QVX files?
What is mapping load?