Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

reload file from excel for end users

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

1 Reply
Qrishna
Specialist III
Specialist III

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.