topic Re: Return Dimension with no data records in QlikView

Return Dimension with no data records

Thu, 08 Nov 2012 22:52:24 GMT

Hi,

I have had a look around and can't really find what I am looking for, I think it is a case of not knowing the exact question to ask.

I have a Dimension where i want to display those that have no associated data rows.

Re: Return Dimension with no data records

johnw — Fri, 09 Nov 2012 23:58:16 GMT

I think you may be asking for one or the other of these:

On the Dimensions tab, checkmark "Show All Values"

On the Presentation tab, uncheck "Suppress Zero-Values"

Re: Return Dimension with no data records

Mon, 10 Dec 2012 05:33:24 GMT

Hi John,

thanks for the reply.

More specifically i have a dimension called Tool. Each tool can be mapped to 0 or many capabilities. Essentially what the tool can do. I have a Table Box which lists the following columns

Tool Name | Capability

If the Capbility is not mapped then a 'dash' is shown to represent a NULL value. A sample of the data is:

Tool Name | Capability

7Zip -

ACDC Inbound

Agility Technical

As the 'Dash' is a null value i can't select it to show all tools with no capability.

Any help would be apprecaited.

Re: Return Dimension with no data records

jeffmartins — Mon, 10 Dec 2012 19:53:41 GMT

Hi Damian Waldron,

To select the tools with no capability you have to follow the following steps:

1) right click on capability list and choose "select possible" option.

2) right click on tool name list and choose "select excluded" option.

A different way to select the tools with no capability is changing the representation of the null value to a string 'NULL' using the following variables in the script:

NULLASVALUE *;

Set NULLVALUE = 'NULL';

Regards