topic Re: if expression looking at multiple dimensions in App Development

if expression looking at multiple dimensions

baderbd — Thu, 05 Sep 2024 18:42:25 GMT

Hi,

I am trying to use an IF expression to look at a list of ship methods and if its on the list return 'Parcel' and if not 'Freight' when I use the expression below it always says 'Freight'. I tried doing a "Match" but I could not get the expression to work. What am I missing?

=if([Ship Method]='FEDEX-Air-International Priority''FEDEX-Air-International Priority Late Day''FEDEX-Air-Next Day Air Early AM''FEDEX-Air-Priority Field Engineer''FEDEX-Air-Priority Overnight''FEDEX-Air-Standard Overnight''FEDEX-AIRHAZ-Priority Overnight''FEDEX-AIRHAZ-Standard Overnight''FEDEX-GROUND-Standard','Package','Freight')

Re: if expression looking at multiple dimensions

datagrrl — Thu, 05 Sep 2024 19:21:59 GMT

Unless I do not know something new in Qlik, you need to create a nested if statement to use multiple values.

Like in this post.

https://community.qlik.com/t5/New-to-Qlik-Analytics/Nested-IF-Statements/td-p/1022597

You can also use the Match expression instead, which is more efficient.

https://community.qlik.com/t5/QlikView-App-Dev/If-statements-for-multiple-values/td-p/659682

So, this should work:

if(match([Ship Method],'FEDEX-Air-International Priority','FEDEX-Air-International Priority Late Day','FEDEX-Air-Next Day Air Early AM','FEDEX-Air-Priority Field Engineer','FEDEX-Air-Priority Overnight','FEDEX-Air-Standard Overnight','FEDEX-AIRHAZ-Priority Overnight','FEDEX-AIRHAZ-Standard Overnight','FEDEX-GROUND-Standard'),'Freight','Parcel')

Re: if expression looking at multiple dimensions

MatheusC — Thu, 05 Sep 2024 19:08:05 GMT

@baderbd

Returning to using Match as mentioned. See it like this:
With the Match function, you will be able to list multiple values that exist in the field in question, but they need to be separated by , and quotation marks ‘’ (‘as it is a textual value’). The syntax should look like this

if(Match([Ship Method],'FEDEX-Air-International Priority',
'FEDEX-Air-International Priority Late Day',
'FEDEX-Air-Next Day Air Early AM',
'FEDEX-Air-Priority Field Engineer',
'FEDEX-Air-Priority Overnight',
'FEDEX-Air-Standard Overnight',
'FEDEX-AIRHAZ-Priority Overnight',
'FEDEX-AIRHAZ-Standard Overnight',
'FEDEX-GROUND-Standard'),'Package','Freight')

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunctions/match.htm#:~:text=The%20match%20function%20compares%20the,The%20comparison%20is%20case%20sensitive.&text=If%20you%20want%20to%20use,comparison%2C%20use%20the%20mixmatch%20function.

- Regards , Matheus