Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hide certain values in chart

I'd like to hide certain values depending on the value of the expression that is chose. I want to display the value in the expression so that other dimensions in the chart will be displayed. I just want one dimension for certain values to display as null. I'm not sure where to begin.

4 Replies
Qrishna
Master
Master

post some sample data.

Not applicable
Author

In the Risk Summary Report chart I would like to hide the value in the % Files Reviewed dimension if the value of the Doc Type is "ASN" or "END".

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

you have two options. See attached.

Option 1:

=if(wildmatch([Doc Type],'ASN','END'),' ',

[Loan Count]/Count({1<[WeekEnding], [Pool] = {'$(vPool)'}>}[Loan ID]))

Option 2:

=[Loan Count]/Count({1<[WeekEnding],[Doc Type]-={'ASN','END'},[Pool] = {'$(vPool)'}>}[Loan ID])

Qrishna
Master
Master

If you want to hide the column '% Files Reviewed' upon selecting 'ASN' or 'END' from 'Doc Type', see attached.