topic how to create a new Field in QlikView

how to create a new Field

dseelam — Sat, 16 Nov 2024 00:37:56 GMT

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?

Re: how to create a new Field

vamsee — Wed, 20 May 2020 21:17:53 GMT

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