There are special functions you can use in a straight table chart in combination with the script defined input fields:
I can't open your QVW currently, so I don't know how your data model looks like.
Why do you keep multiple input field values per key?
Maybe you also want to research 3. party products in the planning domain, maybe something like
Hi, thanks everyone by return!!
Let me explain better what i want...For example, i have a Straight Table with three dimension (Product,Store,DateSell):
Product Store Date Sell | Sum(sold amount) | Input(ANY Values) | Sum(sold amount) * Input(ANY Values)
Cigarrette 001 08-01-2016 | 20 | I set this values | 20 * (I set this values)
Cigarrette 045 06-01-2016 | 10 | I set this values | 10 * (I set this values)
Beer 003 03-01-2016 | 50 | I set this values | 50 * (I set this values)
This column Input(ANY Values) not exist in my data base(QVD), is a column just for put data.
To use INPUTFIELD its work, but a set in scrip a column with any valeus, but have a problem, if i change a values for one line, the qlikview change the value to all the same line...And some times, INPUTFIELD appears duplicity error...Well, unfortunately INPUTFIELD not work to me, i guess...
I hope I have been clear...if this problem have solution, will help me a lot...
I did it Adrian!!!
Folks, i got it, i used INPUTFIELD...
PRUN_UNID_CODIGO AS VEN_UNID_CODIGO,
DT_MOVTO AS DATA,
0 AS QTDE,
0 AS PV,
0 AS PR
Thank you everyone!!!Thank youuu!!!
Now i need export this to .QVD...=/