topic Re: Simplified Set Expression in QlikView

Simplified Set Expression

suryaa30 — Thu, 21 Sep 2017 10:33:10 GMT

Sum({< Year = {'$(=Max(Year))'}, FK_Service = {'0', '2208', '2214'} >} GrossSales_P_RISK_Monthly)

Sum({< Year = {'$(=Max(Year))'}, FK_Service = { '2108'} >} GrossSales_P_RISK_Monthly)

Can someone help me above expression. A-B

PrashantSangle — Thu, 21 Sep 2017 10:36:09 GMT

Hi,

try below

Sum({< Year = {'$(=Max(Year))'}, FK_Service = {'0', '2208', '2214'} >- <Year = {'$(=Max(Year))'}, FK_Service = { '2108'}>} GrossSales_P_RISK_Monthly)

sunny_talwar — Thu, 21 Sep 2017 12:27:15 GMT

One way might be this

Sum({< Year = {'$(=Max(Year))'}>}

If(Match(FK_Service, '0', '2208', '2214'), GrossSales_P_RISK_Monthly,

If(Match(FK_Service, '2108'), -GrossSales_P_RISK_Monthly)))