How to add control data to visual

Q&A
, ,
1

Hi,

I created 2 controls - multiline text - see image

(1) are invoice numbers that is used to search in a dataset to the corresponding invoices

in the second control is the invoice number availabe (2) and the credit (3) that has to be applied to the table in an additional column (4). The credit (3) that has to be applied to the table has obviously to be matching the invoice numbers in the table (5).

in other words for invoice (1) found in (2) should (3) be added in column (4) for each record where (1) =(2) = (5)

image
image831×961 56.6 KB

so it should give something like this as a result

image
image830×494 132 KB

Any suggestions ?

Thanks

2

Hi @christian
do I got it right, that credit isnt part of your dataset and you want to “write data”?
BR

3

Yes, the data of the field credit is not in my dstaset and I would like to show it to make afterwards some calculations with it.

Cristal clear ? :wink:

4

Hi @christian
I guess that’s not possible with just Quick Sight function.
Maybe you can achieve it with an write back “function”.

BR

5

Hi @christian
any update on your side?
BR