Expression, filter out results from one column in chart

[jsqlik33]

Hi,

I am trying to filter out a link to open a PDF when the description chart has a certain value. In other words, if Description is 'Example' it should hide the open pdf link.

This is the expression code to get the url to Open invoice.

if(not IsNull(only({$<Datasource={'APLedger'}>} VoucherNumber)) AND not IsNull(only({$<Datasource={'APLedger'}>} VoucherPath)),

'Open invoice<url>'& only({$<Datasource={'APLedger'}>} VoucherPath) & only({$<Datasource={'APLedger'}>} VoucherNumber) & '.pdf')

Right now I have a solution (in Dimensions) to filter out the whole row with 'Example' as Description, but this does not serve the purpose. We need the row data and want to remove the link to the invoice (or remove open invoice text) as the invoice can contain sensitive information.

=if(Description='Example', Null(),Description)

Do you have ideas how to solve this?

[sunny_talwar · Accepted solution]

Is this link to open the pdf the only expression in the chart? If not, you can try this

If(not IsNull(Only({$<Datasource = {'APLedger'}, DimensionName -= {'Example'}>} VoucherNumber)) and not IsNull(Only({$<Datasource = {'APLedger'}, DimensionName -= {'Example'}>} VoucherPath)),

Only({$<Datasource = {'APLedger'}, DimensionName -= {'Example'}>} 'Open invoice<url>'& VoucherPath & VoucherNumber & '.pdf'))

[jsqlik33]

Hi, thank you for your help! This seems to work like a charm 🙂

[jsqlik33]

What if I need to add more than 'Example' to the filtering? 'Example' or 'Test' or ' Fail'. I tested, but didn't get it correct yet.

[sunny_talwar]

May be this

If(not IsNull(Only({$<Datasource = {'APLedger'}, DimensionName -= {'Example', 'Test', 'Fail'}>} VoucherNumber)) and not IsNull(Only({$<Datasource = {'APLedger'}, DimensionName -= {'Example', 'Test', 'Fail'}>} VoucherPath)),

Only({$<Datasource = {'APLedger'}, DimensionName -= {'Example', 'Test', 'Fail'}>} 'Open invoice<url>'& VoucherPath & VoucherNumber & '.pdf'))