topic Hide certain values in chart in QlikView

Hide certain values in chart

Thu, 16 Jul 2015 19:43:35 GMT

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.

Re: Hide certain values in chart

Qrishna — Thu, 16 Jul 2015 19:53:18 GMT

post some sample data.

Re: Hide certain values in chart

Thu, 16 Jul 2015 19:59:12 GMT

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".

Re: Hide certain values in chart

phaneendra_kunc — Thu, 16 Jul 2015 20:24:25 GMT

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

Re: Hide certain values in chart

Qrishna — Thu, 16 Jul 2015 20:50:48 GMT

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