Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Return Dimension with no data records

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.

1 Solution

Accepted Solutions
jeffmartins
Contributor II

Re: Return Dimension with no data records

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

3 Replies
MVP
MVP

Re: Return Dimension with no data records

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

  • On the Dimensions tab, checkmark "Show All Values"

or

  • On the Presentation tab, uncheck "Suppress Zero-Values"
Not applicable

Re: Return Dimension with no data records

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.

jeffmartins
Contributor II

Re: Return Dimension with no data records

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

Community Browser