Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Doubt about jerarquic dimension and null in a value

Hi i have this for example

ID   adress   Date1      Date2

1     233232             10/10/12     10/10/12

2    2312312            10/11/14     10/6/12

3    12312123          25/10/12       5/10/12

4       44444            

5    1231233       

my expression is a sum of id (number of propertys)

I have "status". This is Date 2 - Date 1 with and if (i do this in the code) and because the number they have different names like "ok", "expired", etc.

And adress

My dimmension is a jerarquic dimmension Status - Adress

The problem is that when i have null values in the data in the graph i have this "-"

I'm thinking about a isnot null or something similar but how i do this in the jerarquic dimmension?

thank you!

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See this document: IntervalMatch and Slowly Changing Dimensions


talk is cheap, supply exceeds demand