Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
New Contributor

InputSum issues

Hi all,

I have a field [Amount] that I am doing the following set analysis on to get the sum on a straight table:SUM({<Source={'Supply'}>}[Amount])

Amount is a field that is loaded in three different tables, each with different source files, and this set analysis differentiates between the different amount values depending on table.

I want to have an InputSum function in a QlikView chart so that the Amount can be altered by, I have already used the InputField ([Amount]) function in the script but I get an error every time I try using the INPUTSUM([Amount]) expression in the pivot chart I am using.

Any advice on what I am doing wrong?

Tags (2)