Creating a dynamic dashboard with input box

[Anonymous]

Hello,

I have been tasked with creating a dynamic dashboard.  There is a table with some per unit sales price in the background. The function of the dashboard is to help sales and supply chain forecast their sales quickly.

What I envision is to have few lines of inputs

Product 1 - Attribute A - Attribute B - Total Qty

Product 2 - Attribute A - Attribute B - Total Qty

....

Product 10 - Attribute A - Attribute B - Total Qty

And this should pull into a table which shows what their forecasted total sales should be. We have been using spreadsheets but we wish to move away from that and use a Qlikview dashboard instead.  Is my task possible?  I have created a dashboard for 1 single input box, but with multiple inputs - how do I handle?

Product Name	Total Sales
Product 1	$1,000,000
Product 2	$500,000
...	$...
Product 10	$25,000
Total Sales	Sum()

[zhadrakas]

hello,

here is a sample script:

INPUTFIELD Attribut_A;

INPUTFIELD Attribut_B;

INPUTFIELD TOTAL_QTY;

TableName:

LOAD Product_Name

          '' as Attribut_A,

          '' as Attribut_B;,

          '' as TOTAL_QTY

FROM YourQVDFile.qvd (qvd);

After that you can create a straight table with your Input fields.

Thats it.

[Anonymous]

Thanks, Tim.

I did that - however I get the following error when I debug:

"Duplicate Keys when loading Input Field".

What am I doing wrong?

[zhadrakas]

Internally, QlikView uses all the non-inputfield fields from the table to create a composite primary key for each inputfield value.
you have to create a link table.

INPUTFIELD Attribut_A;
INPUTFIELD Attribut_B;
INPUTFIELD TOTAL_QTY;

Inputfield_Link:
Load distinct Product_Name,
RowNo() as InputKey
Resident YOUR_PRODUCT_TABLE;

InputTab:
Load RowNo() as InputKey,
'' as Attribut_A,
'' as Attribut_B,
'' as TOTAL_QTY
AutoGenerate peek('InputKey', -1, 'Inputfield_Link');