Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
William2
Contributor III
Contributor III

Variables

Hello experts, 

since I am not able to add a write back table in my App where user can write directly into it I am looking for an alternative. 

I would like to filter a field for example with 50 of 10.000 values. This is no problem because I can enter this values straight into a filter panel. The challenge is that I want to add quatities to every filtered value.

e.g. 

filtered Materialnumber; user added quantites

1234; 50

1323; 12

4324; 30

5235; 20

2353; 10

and so on

these quantities will be used for different calculation so everywhere Materialnumber is 1234 calculate with 50 . 

I am not able to use a reload button to read an excel file dynamically, so user have to input the quantites in front end.

I would also avoid to create a variable for every filtered value. 

Maybe something like a variablelist where I store materialnumber and quantites and a set expression where I iterate through the varialbe liste for calculation ?

I would appreciate some hints or  links to already existing solutions. 

Thank you guys 

Best wishes 

Will  

0 Replies