topic Re: How to Design a "open field" table? in QlikView

How to Design a "open field" table?

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

Hi all,

I have the following Excel table, and I wanted to know if it's posible to do something similar in QV:

What I need for each column is:

Model: drop down with a list to choose from

Area: automatically filled as per model chosen

List price: open field to type in unit value

Discount: calculated field crossing the list price and the quote price

Price: final price quoted

Cost: calculated field based on price and CGP column

CGP%: open field to type wanted CGP%

Total units: calculated field adding all the following columns

Equipment Delivery Schedule: open field to type in qty according to the year to be delivered

Equipment revenue: calculated field multiplying unit price times its qty according to the delivery year

Is it posible to do so? I'm not sure where to begin with for this case, any sugestions?

Thanks!

Re: How to Design a "open field" table?

vishsaggi — Wed, 04 Oct 2017 18:30:05 GMT

May be this:

What I need for each column is:

Model: drop down with a list to choose from

- Use a Multibox for drop down field

Area: automatically filled as per model chosen

- Use this as normal Listbox if your data model is correct with all respective fields all will be connected accordingly and you can see the data changes based on your selections.

List price: open field to type in unit value

- Use this field as INPUTFIELD like INPUTFIELD [List Price]; Then your actual Load statement. This will create a Free field for Listprice where you can delete existing values and enter new ones.

Discount: calculated field crossing the list price and the quote price

Price: final price quoted

Cost: calculated field based on price and CGP column

CGP%: open field to type wanted CGP%

Total units: calculated field adding all the following columns

Share some sample data so that we can see what can be done. The rest of fields are pretty straight forward.

Re: How to Design a "open field" table?

Anonymous — Wed, 04 Oct 2017 18:40:37 GMT

Hi Vishwarath,

Some doubts I have:

Model: drop down with a list to choose from

- Use a Multibox for drop down field

- is it posible to add multiple lines as the image is showing? how?

Area: automatically filled as per model chosen

- Use this as normal Listbox if your data model is correct with all respective fields all will be connected accordingly and you can see the data changes based on your selections.

- this would be a separate object right? is it posible to make all in one object?

List price: open field to type in unit value

- Use this field as INPUTFIELD like INPUTFIELD [List Price]; Then your actual Load statement. This will create a Free field for Listprice where you can delete existing values and enter new ones.

- what type of object should I use?

Re: How to Design a "open field" table?

vishsaggi — Wed, 04 Oct 2017 19:04:32 GMT

We can create a straight table and add these fields into them. If you can sheet some sample data with those respective fieldnames i will mock up a table for you.