Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
DavidMetodoyEmocion
Contributor
Contributor
‎2020-04-28 02:25 PM

Calculated field

Hi

I want to add a new field in order to check if other field (Field1) is null or not.

  • If  Field1 is null, then the calculated field value must be "1"
  • If  Field1 is not null, then the calculated field value must be "0"

Can you help me with the formula?

Thanks a lot!

D

 

Labels (1)
Labels
131 Views
0 Likes
1 Reply
Taoufiq_Zarra
MVP
MVP
‎2020-04-28 06:52 PM

If I understood correctly

=if(isnull(Field),1,0)
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
110 Views
0 Likes