Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
dseelam
Creator II
Creator II

how to create a new Field

Hello All,

Requirement is to know where the selling price coming from 3 source fields listed in below picture, how can i create a new Field source in script which gives info where the price coming from among other 3 Fields?

Capture.PNG

Labels (2)
1 Solution

Accepted Solutions
vamsee
Specialist
Specialist

Try the below if you are sure that Price is found is only one source,

 

If(Len(SAP_PRICE_BY_CUSTOMER)>1, 'SAP_PRICE_BY_CUSTOMER',

If(Len(SAP_PRICE_GENERIC)>1,'SAP_PRICE_GENERIC' ,

If(Len(ORACLESTD_PRICE)>1,'ORACLESTD_PRICE' ,

'Price Source Not Found')))

as Price_Source

 

 

View solution in original post

1 Reply
vamsee
Specialist
Specialist

Try the below if you are sure that Price is found is only one source,

 

If(Len(SAP_PRICE_BY_CUSTOMER)>1, 'SAP_PRICE_BY_CUSTOMER',

If(Len(SAP_PRICE_GENERIC)>1,'SAP_PRICE_GENERIC' ,

If(Len(ORACLESTD_PRICE)>1,'ORACLESTD_PRICE' ,

'Price Source Not Found')))

as Price_Source