Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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'))
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'))
Hi, thank you for your help! This seems to work like a charm 🙂
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.
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'))