topic Double assignment in App Development

Double assignment

andreacossu1 — Sat, 16 Nov 2024 21:33:30 GMT

Hi All!

I have an app loading my data as it should and now I would like to display it in a table. When I write the conditions for each row in the table, it gets the matching data assigned. Now, the problem I have is that each data value can only be assigned to one and only one row. So for example if a data value needs to be assigned in theory to rows 1 and 2, depending on the order of the code it will either be assigned to row 1 OR (exclusive) row 2. However, I need it to be assigned to both. How can that be done in the table interface (Basically I have written a code for the a dimension in Qlik sense which displays the table itself. How can this be modified s.t. a value can be assigned to two (or more) lines.)?

Re: Double assignment

Gysbert_Wassenaar — Tue, 22 Jan 2019 17:15:20 GMT

Can you give an example with data? I have no idea now what you're actually trying to do.

Re: Double assignment

swallace104 — Tue, 22 Jan 2019 17:16:57 GMT

I'm assuming you know that the rows you want the value assigned to are related? If so then you could just create a key that defines that relationship. So you create _GroupingKey with a unique value for each row set. Each row in your dataset gets its corresponding _GroupingKey and you assign the value to the _GroupingKey instead of the row. You can either keep a seperate table with just the _GroupingKey and its proper value or map the value into every row in the dataset via the _GroupingKey. Then it's just a matter of using that value in your table.

Re: Double assignment

andreacossu1 — Wed, 23 Jan 2019 08:37:04 GMT

Seems promising to me. Will try that and then get back to you. In the mean time, I have posted more information on the problem in the thread as a reply to the first contributor to the post.

Re: Double assignment

andreacossu1 — Wed, 23 Jan 2019 08:55:36 GMT

Example of data:

Item 1 – Color : Red ; Height : 1.51m ; Mass : 25kg ; Value : 105

Item 2 – Color : Blue ; Height : 1.51m ; Mass : 25kg ; Value : 200

Row 1 Conditions – Color: All ; Height : All ; Mass: All

Row 2 Conditions – Color: Red ; Height : Above 1.5m ; Mass : All

Row 3 Conditions – Color: Blue ; Height : Above 1.5m ; Mass : All

So then the values should be the following:

Row 1 – Value : 205

Row 2 – Value : 105

Row 3 – Value : 200

The interface I am using is the following (See attachment). The code is written in the first dimension.

Thanks a lot,

Best

Re: Double assignment

Gysbert_Wassenaar — Wed, 23 Jan 2019 14:20:38 GMT

Still don't get it. Can you post a small QS app with example data that demonstrates the problem?