Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to show text on the basis of condition??

Hi

I have created an employee report which has fields present and leave. I want the pivot to show "yes" or "no" for the condition if the employee is present or on leave. I am not getting how to show text on the basis of condition. please help..

1 Solution

Accepted Solutions
Not applicable
Author

hi, I think this will help you

View solution in original post

5 Replies
tresesco
MVP
MVP

If present and leave are different fields, you might try something like:

If(present='Y', 'YES', 'NO')

Assuming your present field has flag value like Y/N

Not applicable
Author

hi, if you can attach an sample application it s better

Not applicable
Author

hi, I think this will help you

Not applicable
Author

Where do you want to show the Text?

if(present = 1,'YES','NO')

Anonymous
Not applicable
Author

Thanks all