9 Replies Latest reply: Feb 5, 2016 3:09 PM by Randy Belknap RSS

    Correct way to create a dimension from data in separate columns?

    Randy Belknap

      If I need to create a dimension out of data that is naturally in separate columns do I do this with SQL before importing it or is there a way to import the data as is and then create a dimension in QlikSense?

       

      Links to examples or discussions of this issue are much appreciated.

       

       

      Here is an example.

       

      Data Fields:

       

        PersonID

        Gender

        Zipcode

        $SpentOnEntertainment

        $SpentOnFood

        $SpentOnTravel

        $SpentOnHealthCare

        $SpentOnHousing

       

      I want to create a pie chart where the segments are Entertainment, Food, Travel, HealthCare, Housing.

       

       

      I know I can use SQL to transform into two tables and import them.

       

        PersonID

        Gender

        Zipcode

       

      and

       

        PersonID

        Category --Values Entertainment, Food, Travel, HealthCare, Housing

        AmtSpent

       

      Is this the correct/natural way to do it, or would import the original table and then do something in QlikSense? 

       

       

      Thanks