Error in Expression

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

Hi All - the expression below is not functioning properly. Each line is intended to populate a bar on a bar chart. It loads from the script but does not populate the bars of a bar chart as it should. I know there are probably better ways to calculate this but looking to understand other options. We are also using the '*' as a wildcard function, but thinking this is not proper usage either. Thanks!!

IF ([Case Type] = 'Employee', Dual('Employee', 1)),
IF ([Case Type] = 'Agent*' AND ([Net Loss (USD)]>10000), Dual('Agent>10k', 2),
IF ([Case Type] = 'Policy*' AND ([Net Loss (USD)]>10000), Dual('POS >10k', 3),
IF ([Case Type] = 'Procure*' AND ([Net Loss (USD)]>100000), Dual('Procurment >10k', 4),
IF ([Case Type] = 'Claim' AND ([Net Loss (USD)]>250000), Dual('Claims >250k', 5),
IF ([Case Type] = 'Under*' AND ([Net Loss (USD)]>250000), Dual('U/W >250k', 6))))))as SigCases,

Re: Error in Expression

stigchel — Tue, 27 Feb 2018 18:53:08 GMT

You close of the first if statement too soon, furthermore use wildmatch to compare with wildcards

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ConditionalFunctions/wildmatch.htm

topic Re: Error in Expression in QlikView

Error in Expression

Re: Error in Expression