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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
Creator III
Creator III

Nulls formatting

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.


nullvalue.PNG




Thanks.

Labels (1)
11 Replies
Thiago_Justen_
MVP
MVP

Viresh,

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

Cheers

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago
Thiago_Justen_
MVP
MVP

Hey Viresh,

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

Cheers

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago