Calculation for each dimension in chart using variables

[#1]

Hello, I have a list of towns and a cash value:

Location	Value
Town 1	6654
Town 2	1213
Town 3	9988
Town 4	4458

I need to provide an input table with a number variable for each town. Then using the number input by the user for each town, calculate Variable*Value=Metric in a bar graph.

[maxgro · Accepted solution]

just an idea in the attachment

you can edit the InputVar field in the tablebox at the top

[HirisH_V7]

Hi ,

Check this,

From your data,

->Create a Input Box and Define a variable.

->In Chart -> Expression -> Sum(Value)*Variable.

Then by passing the value in input box varies your result.

Hope this Helps,

PFA,

Regards,

Hirish

[rajeshforqlikvi]

Hi,

you can take any no of Input box, in this example i have taken only two input box.

Please find attached Qlikview Doc.

[#5]

Maxgro, thanks - now what if I have 4 more values that need the same treatment? Can we make more than 1 INPUTFIELD in a qvw?

[#6]

Just to show what i need a little better, I'm loading Town and Value from the data source. The users will input the "Input Variable". The chart expression will use the "Formula" to produce the chart below. Is INPUTFIELD still a viable solution? Can this even be done?

[HirisH_V7]

Hi,

Like this,

Adding new input field column as other,

PFA

HTH,

Hirish

[#8]

Perfect, thank you.