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: 
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