Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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!

1 Reply
Employee
Employee

Re: Pivot table on QlikSense

Hello Sim,

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:

Loading Excel and File Data (video)

Qlik Sense - Using the Pivot Table Object (video)

from this video index: New to Qlik Sense Videos

In the above video index you will find many informative videos that will help get you started:

This one Understanding the Master Calendar (video) - will show you more about date functions.

Let us know how you do.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Community Browser