Deriving a dimension value.

[Correct_Answer]

Hello All,

I  am trying to create derived field for the below scenario, Can anyone help me on this, 

DataSet 1.

Here, from this table I just want to check and identify SalesOrderId's, which are  having multiple currency types , and need to create a derived column with values as "multi currency" where ever it is applicable and display the same currency type if it is a single currency,

The output would be,

SalesOrderID	Derived_field
45283	MultiCurrency
45283	MultiCurrency
46976	MultiCurrency
46976	MultiCurrency

Thanks In advance

[rwunderlich]

In chart an expression like:

if(count(TOTAL<SalesOrderID> DISTINCT Currency) > 1, 'MultiCurrency', '')

In the script:

Left Join(Sales)
LOAD
  SalesOrderID,
  if(Count(DISTINCT Currency) > 1, 'MultiCurrency', '') as Derived_Field
Resident Sales
Group By SalesOrderID; 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com