topic Re: How can I make 'Show all values' in a Pivot Table work? in QlikView

How can I make 'Show all values' in a Pivot Table work?

Fri, 08 Nov 2013 09:55:47 GMT

Hello

I want a Pivot table to display data in this layout.

Location	Weekday	Monday		Tuesday		Wednesday		Thursday		Friday
		Mor	Aftn	Mor	Aftn	Mor	Aftn	Mor	Aftn	Mor	Aftn
Loc_A
Loc_B
Loc_C

This works well on high level aggregation.

Making selections, columns can disappear because no data are available for that column.

For eg.

Location	Weekday	Monday		Tuesday		Wednesday	Thursday		Friday
		Mor	Aftn	Mor	Aftn	Mor	Mor	Aftn	Mor
Loc_A
Loc_B
Loc_C

Wednesday and Friday afternoon are left out.

I’ve tried the “Dimension” checkboxes “Show all values”, unchecked “Suppress when Values is null” and checked the “Presentation” checkbox “Always fully expanded” and unchecked “Suppress Zero-Values” to keep the layout as above.

What should I do to keep the original layout?

Re: How can I make 'Show all values' in a Pivot Table work?

RSvebeck — Fri, 08 Nov 2013 10:23:49 GMT

Add this to your expression: +sum ({1} 0)

Your expression will then be : Count (Kin_Naamkind) +sum ({1} 0)

Hope it helps,

best Regards,

Robert

Re: How can I make 'Show all values' in a Pivot Table work?

Gysbert_Wassenaar — Fri, 08 Nov 2013 10:25:48 GMT

Kan je zo snel mogelijk je bestand vervangen door eentje zonder privé gegevens van de ouders?

Zie hier voor hoe je gegevens 'veilig' kan maken: Preparing examples for Upload - Reduction and Data Scrambling

Re: How can I make 'Show all values' in a Pivot Table work?

Fri, 08 Nov 2013 10:44:48 GMT

2 options:

1) handle it in sql - use nvl()

2)in presentation tab- fill 'null symbol' & 'missing symbol'

Also, check 'Show All Values' for all dimensions.

Re: How can I make 'Show all values' in a Pivot Table work?

bruno_m_santos — Fri, 08 Nov 2013 10:55:03 GMT

Try use NullasValue to that column in script;