Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
krishna_2644
Valued Contributor III

Re: Hide certain values in chart

post some sample data.

Not applicable

Re: Hide certain values in chart

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
Valued Contributor III

Re: Hide certain values in chart

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])

krishna_2644
Valued Contributor III

Re: Hide certain values in chart

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

Community Browser