Discussion board where members can get started with QlikView.
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.
Go to Solution.
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:
Set NULLVALUE = 'NULL';
I think you may be asking for one or the other of these:
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:
As the 'Dash' is a null value i can't select it to show all tools with no capability.
Any help would be apprecaited.