topic Re: InputField and InputSum in QlikSense in App Development

InputField and InputSum in QlikSense

ederleelefon_gt — Tue, 03 Apr 2018 07:25:51 GMT

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

Re: InputField and InputSum in QlikSense

fspinelli — Tue, 03 Apr 2018 07:31:23 GMT

Hi Lee,

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

Bye

Re: InputField and InputSum in QlikSense

rubenmarin — Tue, 03 Apr 2018 07:39:31 GMT

Hi Lee, Inputsum is not supported in Sense:

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/QlikView-functions-statements-not-suppor…

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

Re: InputField and InputSum in QlikSense

ederleelefon_gt — Tue, 03 Apr 2018 08:02:00 GMT

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.

Re: InputField and InputSum in QlikSense

rubenmarin — Tue, 03 Apr 2018 08:07:33 GMT

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.

Re: InputField and InputSum in QlikSense

ederleelefon_gt — Wed, 04 Apr 2018 01:52:29 GMT

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!

Re: InputField and InputSum in QlikSense

rizaster — Thu, 13 Jun 2019 21:40:44 GMT

Bump, any solution to this?

Re: InputField and InputSum in QlikSense

johngouws — Tue, 01 Oct 2019 06:47:31 GMT

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.

Re: InputField and InputSum in QlikSense

rizaster — Tue, 01 Oct 2019 21:50:40 GMT

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)

Re: InputField and InputSum in QlikSense

tas_taba1 — Wed, 02 Sep 2020 18:39:58 GMT

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.

Re: InputField and InputSum in QlikSense

Modiz — Tue, 27 Sep 2022 14:14:29 GMT

Hi, I am also looking for a solution to this problem. Does anyone know how to do this?

Re: InputField and InputSum in QlikSense

Rita_Ferreira — Mon, 28 Nov 2022 16:16:30 GMT

Hi, I am also looking for the same solution. If anyone knows please do share

Re: InputField and InputSum in QlikSense

HansV86 — Mon, 13 Feb 2023 15:01:24 GMT

Same here...

I just added this issue to the ideas. Please vote on this and lets hope Qlik will integrate the InputSum() function in Qlik Sense as well.

https://community.qlik.com/t5/Suggest-an-Idea/Add-Qlikview-INPUTSUM-function-to-Qlik-Sense-Enterprise/idi-p/2037232#M11917