Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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