Skip to main content

App Development

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

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.