topic Re: Wrong answer for crossing fields selection in App Development

Wrong answer for crossing fields selection

gilson_carciofi — Mon, 20 Dec 2021 21:08:46 GMT

Hello Experts !

I am struggling with an issue regarding the result of crossing the selection of two fields. I have created my data model like that:

What I have to do is: When I select "Voluntario" value in "Natureza_Deslig" field in certain date, "Descrição Movimentação" field must show "PROMOCAO" equal 2, as in the example bellow (figure A). Instead no value is retrieved for "Descrição Movimentação" as figure B shows.

Figure AFigure B

What I have to do for correct that relantion ?

Thanks a lot.

Best Regards.

@hic

@Clever_Anjos

Re: Wrong answer for crossing fields selection

Lisa_P — Tue, 19 May 2020 23:08:08 GMT

What is the contents of your Chave.. Field ? This is obviously the key

Re: Wrong answer for crossing fields selection

gilson_carciofi — Wed, 20 May 2020 01:26:34 GMT

Hi Lisa !

Yes it is.

Matricula & '|' & Data AS [Chave Matricula e Data]

2000529|01/08/2019

2000529|01/10/2019

etc..

Thanks for your support.

Re: Wrong answer for crossing fields selection

Lisa_P — Wed, 20 May 2020 02:01:56 GMT

I don't fully understand the relationships in your data, but check the values of your keys in all tables if you are not getting the relationships you expect.

Re: Wrong answer for crossing fields selection

Gui_Approbato — Wed, 20 May 2020 02:15:10 GMT

What if you link "Demissões" and "Salarial" directly?

Try changing your key between them, like:

In Demissões, change the name [Chave Matricula e Data] to [Chave 2]

In Salarial, duplicate the column but change the name of one of them to [Chave 2] too

See if they interact the way you expect.

Best

Re: Wrong answer for crossing fields selection

gilson_carciofi — Wed, 20 May 2020 05:13:56 GMT

I will see.

Thank you all.

Re: Wrong answer for crossing fields selection

BalaBhaskar_Qlik — Wed, 20 May 2020 09:42:16 GMT

Try to debug the script, how data is loading. First try to load limited tables, filter the data b/w different fields, gradually add other tables too. Again filter the data & check how the association happened b/w tables. Break the script, then easily you could find out the actual issue.

Re: Wrong answer for crossing fields selection

Clever_Anjos — Wed, 20 May 2020 12:47:44 GMT

Please dump your "Chaves d..." table and attach it here, let me check.

I'm guessing you're having different date formats