Is this field "des_referente" or "DES_REFERENTE"? For QlikView it's not the same. Further did you this expression within a textbox and returned it the expected values? Also you need to ensure that the search-string is interpreted as expression and not only as a string, means adding:
Daniele, did Marcus' last post finally get things working? If so, please do not forget to circle pack and use the Accept as Solution button the post(s) that helped you get things working as expected. If you did something different, consider posting that and mark it using the button to let everyone know what you did. If you are still working upon things, leave an update for us.
Regards, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
no sorry not work, my field name is DES_REFERENTE if i put in action on my sheet the expression: = match(DES_REFERENTE, subfield(concat(distinct DES_REFERENTE, ','), ',',1)) it not selected me the first value. if i put this expression in a textarea it show me 1
It will likely help a lot in this case if you can attach a QVW file, so folks can see the data model etc... If there are confidential field data, you can use Settings\Document Properties\Scrambling to scramble those field values...
Regards, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Daniele, thanks for that, I am attaching what I did, unfortunately I am not sure of the why, but I added three text objects to your app and split up the expression you are using into its subcomponents to test, and the issue is with the 'match' piece, that is returning null, but I am going to see if someone else can explain that part, but I checked the Help, and it would seem to me you are missing something here:
Maybe you will be able to sort it out at this point, but perhaps @marcus_sommer may be able to have another look too.
Regards, Brett
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
