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.
