I'm new to Qlikview and I'm having trouble with an expression. I don't have access to change script, but create charts and tables from data generated by a SAP system to show on a webview. My problem is I'm trying to add to an existing expression with no luck.
Thanks for replying and sorry I've taken so long to answer.
I've tried using replace as above and it does remove the document types, but then the other part of the expression
if(Len(KNVP_ADD.PERNR_NAME) ->,'-',KNVP_ADD.PERNR_NAME) doesn't work now no entries are returned at all.
This is the expression I've tried to use it removes the document types, but doesn't show the entries correctly like the original expression did. The edit expression box shows expression OK and I've tried variations on the expression.