1 Reply Latest reply: Sep 9, 2015 5:50 AM by Michael Tarallo RSS

    Pivot table on QlikSense

      Hi,

       

      How do I load data from Excel and work on it? When I drag the Pivot table icon from the Charts selection, I can only add one dimension and one measure but I need all the fields from the original pivot table.

       

      The YT video Qlik Sense developer tutorial - YouTube assumes data has been loaded, but I want to know how to reproduce the same sheet - Fruits and Vegetable Sales, starting from loading the data to creating the same table as shown in the video. Also where can I download the Fruits and Vegetable datasets from QlikSense? BTW, Is there a way to convert dates to months in QlikSense, or must I group them in Excel first before I load to QlikSense?

       

      Please advise.

       

      Thanks!