Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted

Re: Set analysis

May be this

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

View solution in original post

2 Replies
Highlighted

Re: Set analysis

May be this

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

View solution in original post

Highlighted
Partner
Partner

Re: Set analysis

Thank you Sunny.