Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Only show the Null Dimension

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 Typefuel typeengine sizeeqv engine size
Cardiesel300-
Boatdiesel200400
bikepetrol100200
Carpetrol50-
Carpetrol600-
Boatpetrol400800
bikediesel90180
    
Awnser must be:   
Transport Typefuel typeengine sizeeqv engine size
Cardiesel300-
Carpetrol50-
Carpetrol600-
Labels (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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'} >}

View solution in original post

3 Replies
Highlighted
Partner
Partner

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.

Highlighted
Partner
Partner

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'} >}

View solution in original post

Highlighted
Contributor
Contributor

not sure i understand what you mean?

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