topic Formatting of One Row Pivot Table in QlikView

Formatting of One Row Pivot Table

Thu, 07 Apr 2011 19:03:53 GMT

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

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.

Formatting of One Row Pivot Table

stevedark — Thu, 07 Apr 2011 19:51:26 GMT

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

Formatting of One Row Pivot Table

Thu, 07 Apr 2011 20:04:57 GMT

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?

Formatting of One Row Pivot Table

stevedark — Thu, 07 Apr 2011 22:27:01 GMT

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