topic Re: Error in set analysis syntax in QlikView

Error in set analysis syntax

trishita — Wed, 25 Nov 2020 16:16:04 GMT

Can any one tell me what could be the error in using set analysis with multiple ifs..whenever i am using a set analysis statement individually, it is not showing any problem but whenever i AM TRYING TO USE IT FOR SEPARATE CASES its throwing error:

Garbage after expression ','

if (Match([Actual_Fuel_Type],'HSFO'), sum( total {$<Actual_Fuel_Type={'HSFO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000)),

if (Match([Actual_Fuel_Type],'LSDO'), sum( total {$<Actual_Fuel_Type={'LSDO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000)),

if (Match([Actual_Fuel_Type],'HSDO'), sum( total {$<Actual_Fuel_Type={'HSDO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000)),

if (Match([Actual_Fuel_Type],'ULSFO'),sum( total {$<Actual_Fuel_Type={'ULSFO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000)),'Unknown'))))

Note: Individual statements are working fine:

if (Match([Actual_Fuel_Type],'HSFO'), sum( total {$<Actual_Fuel_Type={'HSFO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000))

This is still working but its not working whenever I am using multiple case statements

Re: Error in set analysis syntax

sunny_talwar — Fri, 03 Aug 2018 12:53:03 GMT

I think you are closing all the if statement before the next one begins... try this

If(Match([Actual_Fuel_Type], 'HSFO'), Sum(TOTAL {$<Actual_Fuel_Type = {'HSFO'}>} FUEL_MASS_BEFORE_SOUNDING/1000),

If(Match([Actual_Fuel_Type], 'LSDO'), Sum(TOTAL {$<Actual_Fuel_Type = {'LSDO'}>} FUEL_MASS_BEFORE_SOUNDING/1000),

If(Match([Actual_Fuel_Type], 'HSDO'), Sum(TOTAL {$<Actual_Fuel_Type = {'HSDO'}>} FUEL_MASS_BEFORE_SOUNDING/1000),

If(Match([Actual_Fuel_Type], 'ULSFO'), Sum(TOTAL {$<Actual_Fuel_Type = {'ULSFO'}>} FUEL_MASS_BEFORE_SOUNDING/1000), 'Unknown'))))

Re: Error in set analysis syntax

sunny_talwar — Fri, 03 Aug 2018 12:55:42 GMT

Or try this

Pick(Match([Actual_Fuel_Type], 'HSFO', 'LSDO', 'HSDO', 'ULSFO') + 1,

'Unknown',

Sum(TOTAL {$<Actual_Fuel_Type = {'HSFO'}>} FUEL_MASS_BEFORE_SOUNDING/1000),

Sum(TOTAL {$<Actual_Fuel_Type = {'LSDO'}>} FUEL_MASS_BEFORE_SOUNDING/1000),

Sum(TOTAL {$<Actual_Fuel_Type = {'HSDO'}>} FUEL_MASS_BEFORE_SOUNDING/1000),

Sum(TOTAL {$<Actual_Fuel_Type = {'ULSFO'}>} FUEL_MASS_BEFORE_SOUNDING/1000))

Re: Error in set analysis syntax

trishita — Fri, 03 Aug 2018 13:06:14 GMT

Currently I used the following fixed code:

if (Match([Actual_Fuel_Type],'HSFO'), sum( total {$<Actual_Fuel_Type={'HSFO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'LSDO'), sum( total {$<Actual_Fuel_Type={'LSDO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'HSDO'), sum( total {$<Actual_Fuel_Type={'HSDO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),

if (Match([Actual_Fuel_Type],'ULSFO'),sum( total {$<Actual_Fuel_Type={'ULSFO'}>}FUEL_MASS_BEFORE_SOUNDING/ 1000),'Unknown'

))))

But now I am having the following error:The records are duplicated

Re: Error in set analysis syntax

sunny_talwar — Fri, 03 Aug 2018 13:12:12 GMT

Do you have hidden dimensions in your chart?

Re: Error in set analysis syntax

trishita — Fri, 03 Aug 2018 13:21:51 GMT

Yah I created something fresh..Its working now...

Re: Error in set analysis syntax

sunny_talwar — Fri, 03 Aug 2018 13:25:21 GMT

Awesome, please close the thread by marking correct and helpful responses.

Best,

Sunny