topic Re: Empty row for wrong key (?!) in App Development

Empty row for wrong key (?!)

danimarc12 — Sat, 18 May 2024 12:58:53 GMT

Hello everyone,

I have an issue with my App in QlikSense. Basically I have a table where I want to display two values: sold and target. But I guess I had a wrong connection with my tables, so that's the result:

It's 3 days I'm trying to solve this problem 😥
Could anyone help me?
I have attached my DataLoad script to have a look.

Thank you all! 🙏

Re: Empty row for wrong key (?!)

Vegar — Sat, 18 May 2024 13:44:29 GMT

You have two common field names shared between the StatClienti and Budget table. Is that intentional? Or do get no matching associations with that combo.

It is always a good idea at consider eliminating synthetic keys in your datamodel if you ru n into issues like the one you are having.

Re: Empty row for wrong key (?!)

danimarc12 — Sat, 18 May 2024 14:00:28 GMT

Hi @Vegar ,

thanks for your answer. Actually having two common field names shared between StatClienti and Budget is not intentional but when I run the script, Qlik says me there are no Synthetic keys.
Can you tell me where is the error in my script to solve my issue?

Re: Empty row for wrong key (?!)

rubenmarin — Sun, 19 May 2024 05:18:09 GMT

Hi, from what I see the budget field in the expression is only related to 'marca' and 'cliente', not to desAgent, so the table draws an extra line without desAgent to show the budget.

At the end of the script you do a gouping of the budget by idMArca, codCli and IdAgente, each one witich it's own group and budget field.

I think you will need one that groups by the 3 fields at the same time, so you really have the budget by Marca, Cli and Agente, each row with the budget for all this 3 fields at the same time.

Or if you have already done a concatenation you can try using the Budget_Calc field. The behaviour with this is that selecting any field not related to budget (like Articolo) will make the budget to disappear; this could be ok, because if you don't have the budget by article maybe it's better to not show than showing the budget for the full marca, which would be misleading.

Re: Empty row for wrong key (?!)

danimarc12 — Sun, 19 May 2024 12:00:05 GMT

Hi @rubenmarin ,

thanks for your answer. So, if I want to display the budget also for desAgente how should I write the script correctly?

Re: Empty row for wrong key (?!)

rubenmarin — Sun, 19 May 2024 12:29:30 GMT

Hi, first try with what I posted in bold, use the Budget_Calc field in expression. If that's the field used that would meant that there is no budget for IdAgente or at least for the ones show on the table.

Re: Empty row for wrong key (?!)

danimarc12 — Sun, 19 May 2024 12:39:26 GMT

@rubenmarin I have used this field but the result is the same.. I think there's not concatenation between budget and idAgente in my Editor

Re: Empty row for wrong key (?!)

rubenmarin — Mon, 20 May 2024 06:09:25 GMT

Hi, it's getting hard without the option to make some tests with the data.

I would add a field like 'Budget' as SourceData on the initial budget table. And try to compare with loaded data to check wich fields are missing their values.

Confirm the budget data has informed the agente.