topic Show All Dimensions in QlikView

Show All Dimensions

Wed, 17 Aug 2011 01:35:15 GMT

I'm sure there is an easy way to do this but I just can't work it out.

I have a table of Sales Reps and a table of their Orders that have come in over night.

I want to show a pivot table with ALL of the reps and show the number of orders and $$ they done INCLUDING zeros.

How to do this?

Wed, 17 Aug 2011 05:09:09 GMT

Hello rjurd,

if you want to show nullvalues within a dimension:

check chart props --> dim tab --> settings for selected dim --> show all values

if you want to show nulls in an expression:

uncheck chart props --> presentation tab --> suppress zero values (lower left hand side)

HtH

Roland