topic Re: Field to Input Values in QlikView

Field to Input Values

Anonymous — Wed, 14 Sep 2016 20:00:50 GMT

Hi folks

Is there any way to make a column in a Straight Table be a edit field...i mean, like inputfield you know? or a cell excel?
I am ask this because a have a demand to make a little software, where a client choose a product and input a discount percentage and the last colunm calculation a...whathever, sell price * INPUT(values user), but for each product be a diferente percentage, It depends on what the client put each product...I found a function like with this, is call INPUTFIELD[];, is as script function, i need something to level of chart, and INPUTFIELD[]; it's not worked when i have two valeus distinct for same key...

Sorry if I was not clear, i realy think qlikview don't make something like this, because is not his purpose, but...

sorry by my english

Thanks!!!

Re: Field to Input Values

swuehl — Wed, 14 Sep 2016 20:24:35 GMT

There are special functions you can use in a straight table chart in combination with the script defined input fields:

Special input field aggregation functions ‒ QlikView

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

KliqPlan (Planning Suite)

Re: Field to Input Values

rupamjyotidas — Wed, 14 Sep 2016 20:26:17 GMT

You can write in your script :

INPUTFIELD <FieldName>;

Use the <FieldName> in your table. Let me know how this works for you

Re: Field to Input Values

neelamsaroha157 — Wed, 14 Sep 2016 20:38:40 GMT

I didn't get you....You already have Input Field in your application and you are already doing the sum of two fields.

Can explain it a bit more what result set you want in your current application.

Re: Field to Input Values

Anonymous — Thu, 15 Sep 2016 12:13:00 GMT

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...

Thanks

Re: Field to Input Values

Anonymous — Thu, 15 Sep 2016 19:45:12 GMT

I did it Adrian!!!

Folks, i got it, i used INPUTFIELD...

Script:

INPUTFIELD [QTDE],[PV],[PR],[DATA];

MANUAL:

LOAD

PRUN_PROD_CODIGO,

PRUN_UNID_CODIGO AS VEN_UNID_CODIGO,

DT_MOVTO AS DATA,

0 AS QTDE,

0 AS PV,

0 AS PR

FROM

(qvd);

Thank you everyone!!!Thank youuu!!!

Now i need export this to .QVD...=/

Re: Field to Input Values

Thiago_Justen_ — Tue, 17 Jul 2018 14:30:17 GMT

Matheus,

Here is a good one example to export chart/table to qvd.

http://buffalobi.com/qlikview/qlikview-export-chart-qvd/

Cheers