InputField and InputSum in QlikSense

[ederleelefon_gt]

Hi Qlik,

I hope you can help me with this, I have a difficulty implementing the functionality of QlikView to Qlik Sense

Where as we used to analyze per specific article. For example below, our users is going to input their desired Price on the table then Qlik will compute the sales per Article.

Article	Price	Sold Qty	New Sales
Article A		500	Price * Margin
Article A		500	Price * Margin

Is there any way I can implement the InputField functionality of QlikView to QlikSense?

Thanks in Advance

[fspinelli]

Hi Lee,

try this extension http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8

Bye

[rubenmarin]

Hi Lee, Inputsum is not supported in Sense:

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/QlikView-functions-s...

A workaround can be using extensions to use variables or prepare a quick partial reload that reads from an external file (additional permissions can be required to allow reloads).

[ederleelefon_gt]

Hi Ruben,

Thank you for this, it's saddening that they haven't include it yet.

Already looked at the variable extension but it only allowed one input at a time, not unlike the table above whereas they can further analyze per article let's say for the table above I can have two or more Article example
Article A  Price is 50 * Sold Qty 500 = 25000

Article B Price is 70 * Sold Qty 500= 35000

In the current Input variable this cannot be done.

Because when we use QlikView we can analyze per Article to the distribution for Total.

Any ideas and suggestion would be gladly appreciated.

[rubenmarin]

The other option is to have the data in a external file and prepare quick and/or partial reload for user to update thew app: http://branch.qlik.com/#!/project/56728f52d1e497241ae69836

Or wait for someone that tell us a better option, I also want to know.

[ederleelefon_gt]

Hi Fausto,

Thank you for this, but this will only allow one variable input, We are hoping we can do horizontal analysis for all of my articles, let's say I have 10 different Articles then I want to analyze for each variable having different prices.

For the extension above, this will only allow, one user input and cascade to all the tables, whereas for my purpose for each dimensions I have different targets.

Thanks though!

[rizaster]

Bump, any solution to this?

[johngouws]

Does anyone know if there is any progress in this? Using an extension, even if it can allow for multipile inputs, is still an issue because the Cloud solution does not allow extensions. 

[rizaster]

As far as I am aware, no. Therefore, I had to opt not to use a table. To clarify, I created a "table" in HTML, with each cell being an object (input variable)

[tas_taba1]

Hi, I am still looking for a way to get user input, save it in a variable and use it in the Wildmatch function in qlik sense. Any help will be greatly appreciated. Thank you.