This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I would like to change the field value of the field 'Classificatie' if another field ' [Naam v/d tegenpartij :] ' contains a specific string.
How to check if the field ' [Naam v/d tegenpartij :] ' contains 'DATS' or 'totop' ? I tried the following code:
If( WildMatch([Naam v/d tegenpartij :], '*DATS*', '*totop*' ) , 'Tanken', 'Geen' );
But there is a red line under the comma before Tanken. So what is wrong?
How to change the field value of 'Classificatie' of the table [Transacties] based on the above if function?.
,Thx for your help.
Message was edited by: Koen Bal
This can be solved by modifying the mappingwithwildcards.qvw.
Which can be found in Rob Wunderlichs Cookbook (http://robwunderlich.com/downloads/).
View solution in original post
I'm not sure to understand as well. Could you send us your entire script ?
But you can't do that if you're not in a Load statement.
Hope that helps you,
I added My script in the question attachment.
Since you're using the qvc library, have a look at the CreateWildmapExpression.qvw example. That's what you're going to need. And you'll have to do it in a load statement. You can't use 'loose' statements in your script to change data in a table.
Thx I'll check the CreateWildmapExpression.qvw .
So can I reload a table I've loaded earlier in the script and then start changing values of the 'classificatie field' based upon the values of the field '[Naam v/d tegenpartij :]' ?
Or how should I do it?
Can you please remove your multiple copies of yout answer. thx