topic Re: Pick Match to replace IF with multiple parameters in QlikView

Pick Match to replace IF with multiple parameters

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

I have this condition, how to write Pick(Match ())function to replace it ? Not sure how to use multiple parameters here. Below is the expression -

If([Cancel flag]='N' and [Cancel status]='Y', Red(),

If([Cancel flag]='Y' and [Cancel status]='N', Green()

))

Re: Pick Match to replace IF with multiple parameters

qlikviewwizard — Wed, 28 Mar 2018 03:28:32 GMT

Apply the below example to your requirement.

Example:

Pick(WildMatch(Month, 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'),

'01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12')

It will provide number value for the Month, based on the string value.

Re: Pick Match to replace IF with multiple parameters

shilpan — Wed, 28 Mar 2018 03:35:07 GMT

pick(match([Cancel flag], 'N', [Cancel status], 'Y'), Red(),

match([Cancel flag], 'Y', [Cancel status], 'N'), Green()

)

Re: Pick Match to replace IF with multiple parameters

neha_sharma1275 — Wed, 28 Mar 2018 04:04:39 GMT

Hi Shilpan,

This seems to be not working. Please find attached image, the first column [Account] is where I applied the expression you provided and all other columns have my previous IF statement for colour. You can see all rows are coloured Red when used your expression which is not correct.

Re: Pick Match to replace IF with multiple parameters

neha_sharma1275 — Wed, 28 Mar 2018 04:50:44 GMT

it is fr multiple conditions in match function, can you please provide the exact expression for the condition I mentioned?

Re: Pick Match to replace IF with multiple parameters

tamilarasu — Wed, 28 Mar 2018 04:57:19 GMT

Hi Neha,

Pick(Match([Cancel flag] & [Cancel status], 'NY','YN'),Red(),Green())

Re: Pick Match to replace IF with multiple parameters

jonathandienst — Wed, 28 Mar 2018 04:59:35 GMT

Is there any particular reason for doing so? It is possible, but the expression will be no simpler and will be less intuitive to read.

Re: Pick Match to replace IF with multiple parameters

neha_sharma1275 — Wed, 28 Mar 2018 06:02:32 GMT

I am trying to improve the performance of the application and as I am just looking at the optimization in front end, I thought this is one the replacements which would work and improve the performance

Re: Pick Match to replace IF with multiple parameters

jonathandienst — Wed, 28 Mar 2018 09:44:43 GMT

I doubt you would see a detectable difference in performance, and the Pick(Match()) may even perform worse than the nested if as it is doing a more complex calculation.