Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ederleelefon_gt
New Contributor II

InputField and InputSum in QlikSense

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.

ArticlePriceSold QtyNew Sales
Article A500Price * Margin
Article A500Price * Margin

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

Thanks in Advance

5 Replies
fspinelli
New Contributor II

Re: InputField and InputSum in QlikSense

Re: InputField and InputSum in QlikSense

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
New Contributor II

Re: InputField and InputSum in QlikSense

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

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
New Contributor II

Re: InputField and InputSum in QlikSense

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!

Community Browser