Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Correct_Answer
Contributor II
Contributor II

Deriving a dimension value.

Hello All,

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

DataSet 1.

Correct_Answer_0-1622734975843.png

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,

SalesOrderIDDerived_field
45283MultiCurrency
45283MultiCurrency
46976MultiCurrency
46976MultiCurrency

 

Thanks In advance

 

Labels (1)
  • Other

1 Reply
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