If value = '?' AND fillnull

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am completely new with Qlikview and have an issue where i can use some help with.

I have a a couple of Straight Table views where the dimension with several dimensions:

[ISO Number] , [ISO Domain], Month_Year, count

For each Straight Table view i need to filter on the [ISO Number] and this works fine when i have data.

But i also need this Straight Table view to show the [ISO Number] & [ISO Domain] when there is no data.

Currently i have this search in the [ISO Domain] dimension:

=if([ISO Number]=1,if(isnull([ISO Domain]),'01. Information Security Policies',[ISO Domain]))

The thing is that if there is no data the isnull does not fill the [ISO Domain] with '01. Information Security Policies'

I hope that someone can help me with this amount of explanation.

Stefan

Re: If value = '?' AND fillnull

sunny_talwar — Mon, 01 Oct 2018 16:35:59 GMT

Not sure if this is a case of missing data instead of null... but try this

=If([ISO Number] = 1, If(Len(Trim([ISO Domain])) = 0, '01. Information Security Policies', [ISO Domain]))

For info on missing data, read here NULL handling in QlikView