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: 
charlie2
Contributor III
Contributor III

Interval Match - Sheet with variable Input

Hi,

Is there any possibility to do an interval match directly in the sheet (as a Master Element, for example), in combination with a Variable Input?

I have a table with Volume Based Discounts. Something similar to this:

Min QTYMax QTYDiscount
01000%
1015005%
5011.00010%
1.00110.000.000.00015%

 

In a sheet I have a variable input, where the user can input some quantities. I would like a master element which calculates the discount based on the new input quantities. Is that possible?

Thanks!

0 Replies