Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Is possible to use applymap?

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

ClassIntervalItem
Laptop5K IntervalA


B


C
House10K IntervalD


E

How? Please help.

Tags (1)
Community Browser