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)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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
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.
View solution in original post
What do you mean with 'it doesn't show the output I was expecting'?
Can you describe where exactly it differed?
It was supposed to get a classification,other than the Apply Map default,(GCLASSIFICACAO) based on the product code (CPRODUTO).
Qlik sense is sometime hard on data types in comparison to qlikview
Trye to use apply map with as.
I'm sorry but I didn't get your point...I'm already using as to name (GLASSIFICACAO) the field "generated" by the ApplyMap function.
I may be wrong but & in apply map got my focus
In your second LOAD, the INNER KEEP LOAD, shouldn't you rename your combined key to CHAVE as well, to get a key field between the first two tables?
I think what Jahanzeb is trying to tell you is to use an alias in the mapping load table:
CPRODUCTO&CESTADO_BEM AS "Alias Name here"
I've tried that too but it's still not working...
I've tried that and the output is still the same.