Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm writing a script in Qlik Sense (November version) but when I run the script it doesn't show the output I was expecting.
I've copied the same script to Qlik View and it works just fine!
Find below the script:
Can someone help?
Thanks in advance!
Mensagem editada por: Filipe Oliveira
Mensagem editada por: Filipe Oliveira
Have you tried to just link your tables, so you can check if the key values do match?
I've done that and they actually match..Do you think it could be some kind of "issue" on Qlik Sense...since it works fine on Qlik View?
I would rather guess it's an issue with value interpretation or formatting that corrupts the value matching when mapping.
Can you demonstrate how you've checked that the linked tables match their keys and you get the correct classification?
Sure.
Script:
Output:
Ok, and now add the WHERE clause to the first table and comment out DREFERENCIA from the second table.
I still get the correct output..
Thanks for you help so far
Ok, then create a resident table with just the two fields as in your mapping table and your combined key aliased to CHAVE, also create this key field in your main table.
It worked!
Thanks!
Good to hear!
But did the ApplyMap() worked after all or just the linked tables?
The ApplyMap() worked with another resident table as you said in your previous answer.