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

    Category : Programming & Development

    #cross#tables#straight#qlikview#tutorial#session#10

    0 Comments and 0 replies
This website uses cookies to ensure you get the best experience on our website
Privacy policyAccept and close
arrow_drop_up