Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
aslam24196
Creator
Creator

Table Box in Pivot Mode

How to Visualize a Table Box in Pivot Mode like in the Picture attached below:

Picture1.jpg

Is This Possible in QlikView?

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

That's possible. It's called a "System Table" and it really is a Pivot table, not a Table Box.

In a QVW document with an existing data model, select RightMouseButtonMenu->New Sheet Object->System Table. RightClick the title bar and select "Properties". Check the Chart type (Pivot table icon!) and the properties that make this Pivot into a System Table. That's hoiw you can do it yourself if you start from New Sheet Object->Chart.

View solution in original post

3 Replies
surendraj
Specialist
Specialist

Its Not Possible.table box is static.It can be useful for data representation and testing purpose(whether data is matching or not)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

That's possible. It's called a "System Table" and it really is a Pivot table, not a Table Box.

In a QVW document with an existing data model, select RightMouseButtonMenu->New Sheet Object->System Table. RightClick the title bar and select "Properties". Check the Chart type (Pivot table icon!) and the properties that make this Pivot into a System Table. That's hoiw you can do it yourself if you start from New Sheet Object->Chart.

shiveshsingh
Master
Master

U can use Pivot Table