topic Re: Adding to existing expression in QlikView

Adding to existing expression

Fri, 15 Jun 2012 09:55:32 GMT

Hi Everyone

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.

if(Len(KNVP_ADD.PERNR_NAME) ->,'-',KNVP_ADD.PERNR_NAME)

This is an expression that I was given when I found that the field name KNVP_ADD.PERNR_NAME can in some cases have several name entries behind it.
Causing records in my tables to duplicate.

The expression allows only single entries to be shown and when there are more than one it shows null (and it works).

But I have to add OrderEntry.VBAK.AUART -= {'ZCOM','ZRER','KA','KB'} to the expression.

This field name covers document types, so I don't want to show these document types in my tables.

Any help in accomplishing this would be very welcome.

Thanks Sean

Re: Adding to existing expression

Mon, 18 Jun 2012 06:02:11 GMT

Hi Sean,

You can use Replace() function to remove document types.

Thanks

Supriya

Re: Adding to existing expression

Fri, 22 Jun 2012 11:39:04 GMT

Hi Supriya

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.

=Replace((OrderEntry.VBAK.AUART =-'ZCOM','ZRER','KA','KB'),if(Len(KNVP_ADD.PERNR_NAME) ->,'-', KNVP_ADD.PERNR_NAME))

What could be wrong with the expression I want to remove the documents while still having the second part working as it did originally.

Thanks in advance for your help

Sean