Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Michael_Tarallo
Employee
Employee

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