topic Re: Creating a dynamic dashboard with input box in QlikView

Creating a dynamic dashboard with input box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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()

Re: Creating a dynamic dashboard with input box

zhadrakas — Thu, 25 Jan 2018 07:02:20 GMT

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.

Re: Creating a dynamic dashboard with input box

Anonymous — Thu, 25 Jan 2018 21:38:15 GMT

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?

Re: Creating a dynamic dashboard with input box

zhadrakas — Fri, 26 Jan 2018 08:14:51 GMT

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