Deriving a dimension value.

Correct_Answer — Tue, 30 Nov 2021 18:17:33 GMT

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

Re: Deriving a dimension value.

rwunderlich — Thu, 03 Jun 2021 16:40:14 GMT

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

topic Re: Deriving a dimension value. in App Development

Deriving a dimension value.

Re: Deriving a dimension value.