topic Re: Populating value from Text Objekt into another Text Objekt in QlikView

Populating value from Text Objekt into another Text Objekt

Wed, 15 Jan 2014 11:24:49 GMT

I want to populate a value from one text object into another text object.

I have a client that want to have a data check in their application to check if the data matches another system.

One possible solution for this is to have one text object that makes a summation and calculation in Qlikview and to have on that they populate with a value. No problem there.

I also want to have a check where I calculate the difference between the two boxes. I wonder if it is possible to make that calculation by populating the value from the Textobjekt that is filled in manually?

Re: Populating value from Text Objekt into another Text Objekt

danieloberbilli — Wed, 15 Jan 2014 11:33:43 GMT

I would suggest that you write your manually value in a variable - maybe with an Input Box.

Please find attached

Re: Populating value from Text Objekt into another Text Objekt

Wed, 15 Jan 2014 12:07:00 GMT

Yea I thought about that solution. The problem is that they want to have a lot of checks. They want to make around 150 checks a month so that would be around 150*12=1800 variables. I dont want to create that many variablea to have in the variable list.

Also there is no good way to design the input box so that it looks good.

Re: Populating value from Text Objekt into another Text Objekt

danieloberbilli — Wed, 15 Jan 2014 12:26:55 GMT

Save all reference values in a Field, then load all QV results in a crosstab and join both. Please find attached