Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is the meaning of the formula?

What is the meaning of the formula?

=if(isnull([Job])=-1, 'Manager',[Job]) & ' Total Salary ($' & Chr(39) &'000)'

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

If is true that the field job is null then show the text 'Manager' otherwise Show The value of the field Job followed by the text ' Total Salary ($'000)

hope this helps

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

If is true that the field job is null then show the text 'Manager' otherwise Show The value of the field Job followed by the text ' Total Salary ($'000)

hope this helps

rubenmarin

Hi, isnull() returns -1 when it's true, so:

if(isnull([Job])=-1, 'Manager',[Job]): Returns the Job or 'Manager' if Job is not set

& ' Total Salary ($' & Chr(39) &'000)': This part is weird, it will return a fixed text: " Total Salary ($'000)"