Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jeevays7
Partner - Creator III
Partner - Creator III

Set analysis

Hi All,

The below is my data. 

CurrencySettlement_CurrencyInstrumentTypeMarket ValueOutput
AUDAUDFx Forward1,535,852.500.00
AUDAUDEquity Future443,468.480.00
AUDAUDBond Future280,419.840.00
AUDAUDInterest Rate Future78,829.030.00
BRLCHFCash56,774.7356,774.73
BRLAUDCash54,574.730.00
BRLBRLFx Forward1,031,776.091,031,776.09
CADCADFx Forward1,095,191.661,095,191.66
CADAUDCash579,704.990.00
CADCADEquity Future292,857.42292,857.42
CADCADBond Future-179,203.01-179,203.01
CADCADInterest Rate Future-190,176.83-190,176.83
CHFCHFFx Forward1,905,331.941,905,331.94
CHFCHFCash0.000.00

I need to write a condition in Output column as IF Currency='AUD' then output is "0" OR

Settlement_currency='AUD' and InstrumentType='Cash' then '0' else MarketValue. how to write the above conditions using set analysis? 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum({<Currency = e({<Currency = {'AUD'}>})>-<Settlement_Currency = {'AUD'}, InstrumentType = {'Cash'}>} [Market Value])

View solution in original post

2 Replies
sunny_talwar

May be this

Sum({<Currency = e({<Currency = {'AUD'}>})>-<Settlement_Currency = {'AUD'}, InstrumentType = {'Cash'}>} [Market Value])

jeevays7
Partner - Creator III
Partner - Creator III
Author

Thank you Sunny.