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?
More measures and dimensions can be added via the measures property panel or by dragging and dropping measures / dimensions / fields from the field lists or master items - on top of the pivot table chart object.
Have you seen these videos - I am not sure if you can view them where you are located (office firewall / country restrictions) - but they will show you this process: