Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have script like this
INPUTFIELD Amount1,Amount2;
Fact:
LOAD * INLINE [
Group,Sales,
A,345
B,12
C,45
D,56
E,79
F,12
g,12
h,12
h,4
];
Fact1:
LOAD
*,Sales as Amount1,'' as Amount2,
RecNo() as ID
Resident Fact;
Store Fact Into Fact.qvx;
and there is reload button for end users.. now i want when user click on send to excel on table then when they enter new record and click on reload then want that updated data in table .. how i do this
any help please
try:
INPUTFIELD Amount1,Amount2;
Fact:
LOAD
*,
RecNo() as ID,
Sales as Amount1,
'' as Amount2,;
LOAD * INLINE [
Group,Sales,
A,10
B,12
C,45
D,56
E,79
F,12
g,12
h,12
h,4
];
make sure to use INPUTSUM(Amount1) in the chart.
check out the attached.