Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Creating a dynamic dashboard with input box

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 NameTotal Sales
Product 1$1,000,000
Product 2$500,000
...$...
Product 10$25,000
Total SalesSum()
3 Replies
Specialist II
Specialist II

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.

Highlighted
Contributor II
Contributor II

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?

Highlighted
Specialist II
Specialist II

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');