Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. 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
Highlighted
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');