topic Re: WHat is the difference between Straight table and Table box and Pivot table ?? in QlikView

WHat is the difference between Straight table and Table box and Pivot table ??

nikhilgarg — Wed, 17 Sep 2014 10:03:20 GMT

Hey,

WHat is the difference between Straight table and Table box and Pivot table ??

Please help.

Thanks.

Re: WHat is the difference between Straight table and Table box and Pivot table ??

Wed, 17 Sep 2014 10:08:32 GMT

In table box we can add the dimensions but you can't create an expression

eg: sum(sales) is not possible

pivot table is better grouping

you can have a look at the below link for more detail

Re: Totals in Pivot Tables vs Straight Tables

Re: WHat is the difference between Straight table and Table box and Pivot table ??

Wed, 17 Sep 2014 10:09:39 GMT

Straight table: it has grand total,hiding column,accumulation,dimension limits tab,mini chart,need atleast one expression.

Pivot table: it has grand total and sub total,(accumulation,hiding column,mini chart,dimension limits tab are not available), need atleast one expression

Table box: it has only fields not expressions

Re: WHat is the difference between Straight table and Table box and Pivot table ??

jagan — Wed, 17 Sep 2014 10:10:15 GMT

Hi,

TableBox:

You do not have expressions, just specify the dimensions you required.

Grouping is not possible.

Straight Table:

You have to write one or more expressions.

Grouping is not possible.

Sub totals is not possible.

Expression Total and Sum of rows mode is available for expression.

Better performance.

Pivoting of dimension is not possible.

COLAPSE/EXPAND column is not possible.

Pivot Table:

You have to write one or more expressions.

Grouping is possible.

Sub totals is possible.

Expression Total mode is available for expression.

Poor performance when compared to Straight table.

Pivoting of dimension is possible.

COLAPSE/EXPAND column is possible.

Check this link : Re: Pivot Table vs Straight Table (Performance)

Hope this helps you.

Regards,

Jagan.

Re: WHat is the difference between Straight table and Table box and Pivot table ??

ychaitanya — Wed, 17 Sep 2014 10:10:23 GMT

Straight Table:

Its a tabular form of viewing your dimensions .

No Goupings are possible

NO Sub Totals or Partial Sums

Scope of Redundant Dat-- difficult for use with Large Volumes

Pivot Table:

Groupings Possible

By Using Expand/Collapse you can interact with your data

Partial Sums make you more insight of the Data

We have No Dimension Limits tab for Pivoting.

Regards

Chaitanya

Re: WHat is the difference between Straight table and Table box and Pivot table ??

Wed, 17 Sep 2014 10:27:07 GMT

A Straight table is like a Standard Table, with Row Columns. You have dimensions and expressions.

A Pivot Table - Its similar to excel pivot table, where you can do data grouping, collapsing & expanding columns, based on dimensions

A Table Box - Its a table to list various dimensions and their existing combinations. It does not include an Expression though.

Re: WHat is the difference between Straight table and Table box and Pivot table ??

nikhilgarg — Wed, 17 Sep 2014 11:08:41 GMT

Hey,

But i can expand and collapse column in straight table. Even grouping is also possible by Edit Grouping option in straight table. And where this sub total is used ??

Please help.

Thanks.

Re: WHat is the difference between Straight table and Table box and Pivot table ??

Wed, 17 Sep 2014 11:10:14 GMT

DIFFERENCE BETWEEN STRAIGHT AND PIVOT TABLE
	PIVOT TABLE	STRAIGHT TABLE
ASCENDING/DESCENDING CHANGE OPTION ON COLUMNS	NO	YES
SEARCHING/DROPDOWN SELECT ON COLUMN	YES	YES
COLAPSE/EXPAND COLUMN	YES	NO
GROUPING	YES	NO
DRAG AND DROP COLUMN	YES	YES
SUB TOTAL	YES	NO
TOTAL	YES	YES
DRAG EXPRESSION	NO	YES
HIDE COLUMN OPTION PERMANENTLY BUT INTERNALLY WORK	NO	YES
TOTAL MODE (NO TOTAL, EXPRESSION TOTAL, SUM OF ROWS) OPTION ENABLE	NO	YES

A pivot table is better at grouping: you can easily see which group a specific row belongs to, and a group can have a subtotal. You can also display a pivot table like a cross table (one or several horizontal dimensions). But when you sort a pivot table, you have to sort it first according to the first dimension, then according to the next, etc. You cannot sort it any way you want.

A straight table is better at sorting than a pivot table: you can sort it according to any column. But it is not so good at grouping. Subtotals are not possible, for instance.

Re: WHat is the difference between Straight table and Table box and Pivot table ??

Wed, 17 Sep 2014 11:39:16 GMT

Hi Nikhil,

If you are practicing, have you created both the tables ? Straight and Pivot ?

Which book or tutorial are you referring, I can guide you from there, it will be easy for you to understand.

Regards

Pankaj

Re: WHat is the difference between Straight table and Table box and Pivot table ??

Wed, 17 Sep 2014 11:44:04 GMT

Hi Nikhil,

There is a Qlikview Tutorial available on Qlikview Website - http://www.qlik.com/us/services/training/free-training. You can download this, and this has a PDF. Chapter - 6, page 77 of the PDF, talks in details about Straight and Pivot Tables. You can read and practice as well, that the best way to understand.

You will understand the differences as well.

Regards

Pankaj

Re: WHat is the difference between Straight table and Table box and Pivot table ??

nikhilgarg — Wed, 17 Sep 2014 11:49:58 GMT

Hey,

Thanx a lot .

Re: WHat is the difference between Straight table and Table box and Pivot table ??

Wed, 17 Sep 2014 12:37:54 GMT

Hi Nikhil,

Welcome

If this is correct or is helpful, please mark the answer as correct to close the thread, so that it will help others ?

Regards

Pankaj

Re: WHat is the difference between Straight table and Table box and Pivot table ??

jagan — Thu, 18 Sep 2014 01:30:56 GMT

Hi Nikhil,

Expand and Collapse is not available in Straight table, you will get + symbol for Expand/Collapse in Pivot table, but it is not there in Straight table.

Grouping and Subtotals are available in Pivot table only, for example if you Country and Product dimensions then in Pivot table you can get Subtotals by Country, but it is not possible in Straight table.

Regards,

Jagan.

Re: WHat is the difference between Straight table and Table box and Pivot table ??

nikhilgarg — Thu, 18 Sep 2014 10:38:22 GMT

HEy,

How can i show subtotals or grouping and is there any icon for this ??

Thanks.

Re: WHat is the difference between Straight table and Table box and Pivot table ??

Thu, 18 Sep 2014 10:44:15 GMT

Grouping will happen automatically, if you add two or more dimensions. For Subtotals - Go to presentation tab, select the dimension, you want to see sub totals for. Then set indicator - show partial sums

Regards

Pankaj

Re: WHat is the difference between Straight table and Table box and Pivot table ??

nikhilgarg — Thu, 18 Sep 2014 10:46:34 GMT

Hey,

Thanks for telling. I just now get how to show subtotals and what does it mean.

Thanks.