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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting of One Row Pivot Table

I have data that was loaded using the following LOAD Script

LOAD
Year(ExtractDate) AS Year
,SUM(Losses) AS Losses
RESIDENT
lookupMasterServicer
WHERE
ApplyMap('Map_Losses', Losses, 'False') <> 'True'
GROUP
BY Year(ExtractDate);

So basically it is just a summary of Amounts by year... That I want to display in a pivot table that looks similar to the following

error loading image

My problem is the formatting looks wacky for a one row pivoted table after I drag the year horizontally over the losses column. How can correct this to make it look a little more pleasing to the eye.

1 Solution

Accepted Solutions
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there,

You may be better with a straight table and change it to be displayed Horizontal on the Presentation tab.

You can also play with hiding captions to make things look a bit tidier - particularly with small amounts of data. Experiment with other options on the presentation tab - for example you could suppress headers and create a new 'header' with a text box instead. This gives you more freedom of how to place stuff.

Good luck!

Steve

View solution in original post

3 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there,

You may be better with a straight table and change it to be displayed Horizontal on the Presentation tab.

You can also play with hiding captions to make things look a bit tidier - particularly with small amounts of data. Experiment with other options on the presentation tab - for example you could suppress headers and create a new 'header' with a text box instead. This gives you more freedom of how to place stuff.

Good luck!

Steve

Not applicable
Author

Thank-you for the quick response...

I really like your answer. Just one last thing before I am completely satisfied... The auto total, how do I get rid of that?

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi there,

If you are now on a straight table go to the Expressions tab and select No Totals for each expression that you have. On a pivot totals are turned on and off for each dimension on the Presentation tab (Show partial sums).

Cheers,
Steve