Select a value from a 2-Dimension Table

radokotbk — Mon, 26 Mar 2012 13:35:19 GMT

I have a table like this for rates:

Sales/Transactions	0-100	101-250
0-1500	2,5%	2,65%
1501-3000	2,6%	2,76%
3001-4500	2,7%	2,9%

So i load info for Sales and Transactions from a lot of stores, and i need to show something like this:

Store	Sales	Transactions	Rate
Store 1	786	80	2,5%
Store 2	3250	215	2,9%

Im trying to figure out how to do this. I change the format of the first table to a 4 column table (SalesMin, SalesMax, TransactionsMin,TransactionsMax,Rate) but i cant make it so far.

Thanks for your help and sorry my english.

Re: Select a value from a 2-Dimension Table

hic — Mon, 26 Mar 2012 14:31:21 GMT

Thera are several ways to do this. I have a suggested solution with a double intervalmatch, where you need to to match the sales of a store to the relevant range, then the transaction number to the relevant range, and finally make a composite key of the two intervalmatches. Attached you will find the script in a text file.

Good luck!

/HIC

topic Re: Select a value from a 2-Dimension Table in QlikView

Select a value from a 2-Dimension Table

Re: Select a value from a 2-Dimension Table