Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Master
Master

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.