Cross tables and Straight tables - QlikView Tutorial - Session 10
In this session you will learn about Cross tables and Straight tables
Cross Tables
------------------
Cross Tables contain some matrix of data
We should not Load cross tables as it is
These are not good for analysis
We need to Cross Tables into Straight Table Format
Give 'Crosstable' Prefix before LOAD or SELECT Statement
Crosstable(AttributeFieldname,DataFieldName,No.ofQualiferFields) Load * .................;
Crosstable(Month,Sales) Load * ............;
Year,Jan,Feb
2014,20,25
2015,30,40
Crosstable(Month,Sales,2) LOAD * .................;
Salesman,Year,Jan,Feb
A,2015,20,25
B,2015,40,60
On this page of the site you can watch the video online Cross tables and Straight tables - QlikView Tutorial - Session 10 with a duration of hours minute second in good quality, which was uploaded by the user Trending Courses 04 December 2018, share the link with friends and acquaintances, this video has already been watched 483 times on youtube and it was liked by 4 viewers. Enjoy your viewing!
