Hi,
is there a way to use apply map or function in qlikview, rather than using nested if statement..
ITEMS UNIT PRICE CLASS
A 10,000 LAPTOP
B 13,000 LAPTOP
C 16,000 LAPTOP
D 10,000 HOUSE
E 25,000 HOUSE
So I have intervals
For Class LAPTOP:
Intervals Minimum Maximum
5K Interval 10,000 15,000
5K Interval 15,001 20,000
For Class HOUSE
Intervals Minimum Maximum
10K Interval 10,000 20,000
10K Interval 20,001 30,000
So, just wanna ask if i can use applymap function to these, or simply still use the nested if, so that I could have this report
Class | Interval | Item
|
---|
Laptop | 5K Interval | A |
|
| B |
|
| C |
House | 10K Interval | D |
|
| E |
How? Please help.