Navigation:  Using the ApplyBI Spreadsheet >

Working on the ApplyBI Spreadsheet

Previous pageReturn to chapter overviewNext page

 

Learn how to use an ApplyBI Spreadsheet through the following chapters.

How to use ApplyBI
ApplyBI Spreadsheet functionality
ApplyBI Spreadsheet text formatting
ApplyBI Spreadsheet sheet formatting
Saving

 

How you can use your ApplyBI Spreadsheet.

You can use the ApplyBI Spreadsheet in the following ways.

 

       Integrate Your Spreadsheet Into Qlik.

You can have true data integrity by Uploading your excel spreadsheet into Qlik and use the Qlik functionality.

Use the File drop down menu and Upload you excel spreadsheet either Overwriting the old one or Appending new Sheets on it.

In the picture below you can see the File drop down menu.

spreadfile

 

       Use the fields you already have in your Qlikview document

You can use the fields of your Qlik document as Dimensions or Expressions like in any other Qlikview Object (Tables, Pivot etc).

Right click on the ApplyBI spreadsheet and choose properties. Then add the desired dimensions and expressions.

In the picture below you can see the "Properties" menu.

spreadproperties

 

       Combine the data of your Spreadsheet with the fields you already have in your Qlikview document.

After uploading your Excel Spreadsheet into the ApplyBI you can add a new sheet and use the Excel data in combination with the fields of your Qlik document

Right click on the ApplyBI spreadsheet

 

ApplyBI Spreadsheet functionality.

After you creating the ApplyBI Spreadsheet you can use the Spreadsheet Formula Functions and the ApplyBI Formula Functions to manipulate your data.

You can use the Spreadsheet Formula Functions by begin writing in the appropriate cell the "=" character and then the first letters of the desired function.

An autocomplete window will helps you syntax the formula.

Or you can use the ApplyBI Formula Functions by clicking the fx button above the letter captions of the spreadsheet.

In the picture below you can see the fx button.

spreadfx

 

ApplyBI Spreadsheet text formatting.

You can format text using the Spreadsheet Home menu.

It has the most favorite text format functions divided into four categories.

Font
Alignment
Merge
Numbers

In the picture below you can see the Home menu.

spreadhome

 

ApplyBI Spreadsheet sheet formatting.

You can delete, insert or format cells, columns, rows or entire sheets using the Spreadsheet Additional menu.

You cal also Sort your data or use the Auto Filter Row Function.

The functions of this menu are divided into two categories.

Cells
Short and Filter

In the pictures below you can see the Additional menu and its sub menus.

spreadadditional

Cells --> Insert

adittionalinsert

Cells --> Delete

additionaldel

Cells --> Format

additionalformat

Short and Filter

addtisort

       

Saving

Before Saving your Qlikview Document you must Save the ApplyBI Spreadsheet.

In the File menu use the Save button. Then you can save your Qlikview Document safely.