Script works on QlikView but doesn't work on Qlik Sense

[Anonymous]

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

[swuehl]

What do you mean with 'it doesn't show the output I was expecting'?

Can you describe where exactly it differed?

[Anonymous]

Hi Stefan,

It was supposed to get a classification,other than the Apply Map default,(GCLASSIFICACAO) based on the product code (CPRODUTO).

[zebhashmi]

Qlik sense is sometime hard on data types in comparison to qlikview

Trye to use apply map with as.

Regards

[Anonymous]

Hi Jahanzeb,

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.

[zebhashmi]

I may be wrong but & in apply map got my focus

[swuehl]

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?

[clondono]

I think what Jahanzeb is trying to tell you is to use an alias in the mapping load table:

Map_Classif_Prod:

Mapping Load

CPRODUCTO&CESTADO_BEM    AS      "Alias Name here"

.....

.....

Thanks,

Carlos

[Anonymous]

I've tried that too but it's still not working...

[Anonymous]

Hi Carlos,

I've tried that and the output is still the same.