Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sivapriya_d
Creator
Creator

Suppress when val is Null

Hi All,

I am using one table in my dashboard and selected Suppress when value is null option. Its working fine. But I just wanted showcase one column in the table with Values even the other columns having "Null" values.

For Example my table is like this

If I give suppress when value is null based on ID, the last row wont be available .What  i need to show is for the over all table view i don't need Null ID rows but when i made selection over Name filter the table should show Name column like below

Is it possible?.

Thanks,

Siva

1 Solution

Accepted Solutions
sibin_jacob
Creator III
Creator III

Try this one for your ID dimension

if(GetSelectedCount(Name)=1 and isnull(ID),'',ID)

Check Supress when value is null

View solution in original post

5 Replies
sibin_jacob
Creator III
Creator III

Try this one for your ID dimension

if(GetSelectedCount(Name)=1 and isnull(ID),'',ID)

Check Supress when value is null

MarioCenteno
Creator III
Creator III

Try

=Alt(SUM(id), 0)

Sivapriya_d
Creator
Creator
Author

Thanks its working .But i am not getting the first column

Cheers.

MarioCenteno
Creator III
Creator III

Try

=Aggr(Alt([name],0),ID)


Or

Alt(id, 0)




Sivapriya_d
Creator
Creator
Author

Thanks Sibin.Its Working

Cheers,

Siva