topic How to do nested Pick Match expression? in QlikView

How to do nested Pick Match expression?

jblomqvist — Fri, 28 Aug 2015 14:26:26 GMT

Hello

I am trying to use the Pick Match expression to do the following.

If EMEA is selected, show orders.

If Asia is shown, show Sales.

My Pick Match expression currently looks like:

But this does not work.

How can I create a nested example like this?

Re: How to do nested Pick Match expression?

Peter_Cammaert — Fri, 28 Aug 2015 14:33:08 GMT

Why would you?

I think this does the job:

=Pick(Match(DivisionName, 'EMEA', 'Asia'), Count(Distinct OrderID), Sum(LineSalesAmount))

Note: this will only work 100% of the time if used in a table with DivisionName as (one of the) Dimension. If you put this in a text box, you must make sure that exactly one DivisionName is selected at all times, or you will get no results.

Re: How to do nested Pick Match expression?

jblomqvist — Fri, 28 Aug 2015 14:49:58 GMT

Hi you are right. I got my syntax mixed up. It is a sequence I forgot

Is there a way to provide an else using pick match?

E.g. If nothing is selected then it should say 'Nothing to display'?

Re: How to do nested Pick Match expression?

Qrishna — Fri, 28 Aug 2015 14:56:07 GMT

try:

if(getselectedcount(yourselectionfield)>0,

Pick(Match(DivisionName, 'EMEA', 'Asia'), Count(Distinct OrderID), Sum(LineSalesAmount)),

'Nothing to display')

Re: How to do nested Pick Match expression?

Peter_Cammaert — Fri, 28 Aug 2015 16:06:42 GMT

IMHO using Pick(Match()) in this case doesn't offer much of an advantage over something simple like:

=IF (DivisionName='EMEA', Count(Distinct OrderID),

IF (DivisionName = 'Asia', Sum(LineSalesAmount), 'Nothing to show'))

Peter