Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
honeyasha
Contributor III
Contributor III

Difference between straight ,pivot and table box in qlikview

Can any one explain the difference between straight ,pivot and table box

2 Replies
vishsaggi
Champion III
Champion III

Read here:

Difference between straight table and pivot table

Also read the Reference Manual.

To give you a brief idea

Straight table: Displays data one row per dimension with > 1 expressions. You have dimension limits tab to show top and bottom rows based on high and low ranks.

Pivot table: Groups the data on no. of dimensions used with >1 expressions. You can move your dimensions to show as column values as rows and rows columns. No dimensions limits in this you have to use rank() and Aggr() to show top and bottom values.

Table box: It is just a table with columns and rows not expressions can be added. This is just used to display data as is.

honeyasha
Contributor III
Contributor III
Author

Thanks for response and it is very helpful.