Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
How? Please help.