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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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.

11 Replies
Thiago_Justen_

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_

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