topic Re: Var as an input field in a stright table in QlikView

Var as an input field in a stright table

shahafei2 — Thu, 06 Aug 2020 09:25:21 GMT

Hi all,

I have a data table that contains 7 sites (rows)

I used a for loop in my script to generate 3 variables for each site

vX_Site1, vY_Site1,vZ_Site1

vX_Site2, vY_Site2,vZ_Site1

....

vX_Site7, vY_Site7,vZ_Site1

I would like to use those variables as an input field table that will look like:

SITE1 SITE2 SITE3 SITE4 SITE5 SITE6 SITE7

X vX_Site1 vX_Site2 vX_Site3 vX_Site4 vX_Site5 vX_Site6 vX_Site7

Y vY_Site1 vY_Site2 vY_Site3 vY_Site4 vY_Site5 vY_Site6 vY_Site7

Z vZ_Site1 vZ_Site2 vZ_Site3 vZ_Site4 vZ_Site5 vZ_Site6 vZ_Site7

The goal is that the user will be able to edit the variables and to see how it impacts the calculations in a straight table

any ideas?

Re: Var as an input field in a stright table

fosuzuki — Thu, 06 Aug 2020 15:14:56 GMT

I think it is not possible to use the table object to edit the values in the variables. So I suggest you to use the Input Box object and adjust the layout with some textboxes and lines to make it look like a table. 🙂

Re: Var as an input field in a stright table

shahafei2 — Sun, 09 Aug 2020 06:36:59 GMT

Thanks

It is possible to have an input box without the var name/label and the equal sign ?

(to present the input box as an empty cell)

Re: Var as an input field in a stright table

fosuzuki — Mon, 10 Aug 2020 11:14:53 GMT

Yes - you can leave the variable label blank, and uncheck the option "Show equal sign" 🙂

Re: Var as an input field in a stright table

shahafei2 — Mon, 10 Aug 2020 11:58:26 GMT

Thanks, that's what I will do.

I have just been hoped that there is a built-in solution that will cancel the label area and will allow me to have the input area only(instead).

Re: Var as an input field in a stright table

fosuzuki — Mon, 10 Aug 2020 13:06:56 GMT

Think of the object as a table with 2 cells. The first cell is the label, and the second is the equal sign + the variable content. You can hover the mouse over the object, find the transparent divisor of the cells, and drag it to the left. This will at least minimize the space used for the first cell.