Only show the Null Dimension

[andre_avenant]

Hello

So I have a dimension, lets call this eqv engine size. The eqv engine size has Null values (-) in the data set. I want to have a set analysis that will only allow it to show the data on let say for example car to show the - (null) value. So i will then create 3 different straight tables, one to display car,boat and bike with the help of the set analysis

Transport Type	fuel type	engine size	eqv engine size
Car	diesel	300	-
Boat	diesel	200	400
bike	petrol	100	200
Car	petrol	50	-
Car	petrol	600	-
Boat	petrol	400	800
bike	diesel	90	180
Awnser must be:
Transport Type	fuel type	engine size	eqv engine size
Car	diesel	300	-
Car	petrol	50	-
Car	petrol	600	-

[gmenoutis]

I'd use {$-1<[eqv engine size]={"*"}>}

However, your question seems a bit incomplete. What do you want the set analysis for. A measure? A measure cannot hide all rows if other measures have different set analyses. A calculated dimension? This merits more cereful design and explanations.

[agigliotti · Accepted solution]

in the script you can do something as below:

load
...
if( isnull([engine size]), 'null', [engine size] ) as [engine size]

and in the UI use set analysis {< [engine size] = {'null'} >}

[andre_avenant]

not sure i understand what you mean?

These are all dimensions, no measures, need to use a straight table