topic Re: Nulls formatting in QlikView

Nulls formatting

vireshkolagimat — Tue, 13 Feb 2018 11:00:58 GMT

Hi All,

I have the below data and i would like to show 100% wherever the value fullfilled is Null(-).

I tried the expression like if(isnull([Value Fullfilled]),'100%',[Value Fullfilled]) but not getting the expected result.

Thanks.

Re: Nulls formatting

YoussefBelloum — Tue, 13 Feb 2018 11:09:11 GMT

Hi,

you can try this, you will found it at the bottom of the presentation tab of this type of chart you're using:

you can replace null values and missing values.

Re: Nulls formatting

vireshkolagimat — Tue, 13 Feb 2018 11:27:49 GMT

Hi, I tried the above steps but it doesn't have any effect. These setting will apply to the whole chart.

But i need to format only the value fulfilled column.

Thank you.

Re: Nulls formatting

Thiago_Justen_ — Tue, 13 Feb 2018 16:56:33 GMT

What about this:

If(len(trim([Value Fullfilled]))= 0 or [Value Fullfilled]='NULL' or [Value Fullfilled] ='-', '100%', [Value Fullfilled])

Re: Nulls formatting

YoussefBelloum — Tue, 13 Feb 2018 17:19:18 GMT

I would suggest this:

If(len(trim([Value Fullfilled]))= 0 or [Value Fullfilled]='' or isnull([Value Fullfilled]), '100%', [Value Fullfilled])

Re: Nulls formatting

Thiago_Justen_ — Tue, 13 Feb 2018 17:36:25 GMT

Handling with null values is more complicated than we sometimes imagine.

Re: Nulls formatting

vireshkolagimat — Wed, 14 Feb 2018 10:41:09 GMT

Hi thank you. Its working as expected.

Re: Nulls formatting

vireshkolagimat — Wed, 14 Feb 2018 10:41:59 GMT

Yeah it worked. thanks

Re: Nulls formatting

YoussefBelloum — Wed, 14 Feb 2018 11:00:38 GMT

You're welcome !

don't forget to close the thread by marking correct and helpful answers

Re: Nulls formatting

vireshkolagimat — Wed, 14 Feb 2018 12:15:01 GMT

yes i did.

Re: Nulls formatting

Thiago_Justen_ — Wed, 14 Feb 2018 12:44:12 GMT

Viresh,

As Youssef said, please close the thread by marking helpful and correct responses.

Cheers

Re: Nulls formatting

Thiago_Justen_ — Wed, 21 Feb 2018 12:29:45 GMT

Hey Viresh,

Any news about it? If this thread is solved, please let us know by marking the correct answer.

Cheers