Creation of a variable and use it to color table rows
Hi all,
I'm new to this forum and relative new the QlikView. I've got a question about the creation and usage of variables and I hope you can give me some hints into the correct direction. At the moment, I use a standard load format to load my data (from excel and an Oracle db). To display this data, I use the 'Standard Table Graph' to display these values. Recently, I discovered that I can color these values according to an expression.
However, I've got a question about creation a new variable in a load script (per object: Artikelnummer) dynamically (so, a expression in the load like: value = (x * y) / z). I plan to use this value to define in which color my table row has to be painted. X, y and z have to be values from the excel file or Oracle database.
Could you point me to any documentation describing this process or give me a simple example? Thank very much in advance!
