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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-05-25 04:26 AM

look up or recursive find?

Hi all.

i have a problem that I cant solve in a good way.

i will simplify the problem so everyone can undestand.

I have 2 tables.

One is a table with transactions of Custormers something like.

IN dimension:

     NIF-code-name-order-products

IN expresions:

     Sales

     Total Sales

     Gross Sales....

and have other Table (linked by NIF)

NIF - MINIMUN-MAXIMUN-DISCOUNT

In this table we have a discount per client base on minimun and maximun Sales.

Example:

A20022002     10.000     20.000     1%

A20022002     20.000     30.000     2%

A20022002     30.000     40.000     3%

A20022002     40.000     990.000    4%

so the want that i need to do is, in the master table I want to put the discount. based on total sales. Any help will be very appreciated.

1,109 Views
0 Likes
0 Replies