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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

0 Replies