Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to ignore null/NA values in the expression values displayed in the pivot table

Hi all ,

i have the below given expression in the pivot table , which displays NA or characteristic names in the pivot table.

=IF([Current Rating]-[Requirement Rating]<0,'NA',[Characteristics Name])

i want to ignore the NA values in the expression result and display in the pivot table ,

how can we do this ,?

share any helpful thoughts on this .

Thanks

1 Solution

Accepted Solutions
chinnuchinni
Creator III
Creator III

did you try this ?



=IF([Current Rating]-[Requirement Rating]>0,[Characteristics Name])

View solution in original post

2 Replies
chinnuchinni
Creator III
Creator III

did you try this ?



=IF([Current Rating]-[Requirement Rating]>0,[Characteristics Name])

Anonymous
Not applicable
Author

Hi Praveen, 

Thanks for the suggestion..

thinking of all complex ways i didn't try this simple option .

now it works

Thanks a lot.