topic Re: Another Question about Using Pick for Formatting in QlikView

Another Question about Using Pick for Formatting

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

Hello-

You guys helped me a couple weeks ago. I have been working with Qlikview for a couple years, but the Pick function is one I haven't completely wrapped my head around. I have been told it performs better than an If statement, and it should always be used instead of IF.

I have attached a document. I am using a straight table chart as navigation and wish to format the currently selected value. Pretty basic if statement would get me what I am looking for.

This is a dumbed down version of what I am doing, so you don't have to worry about forcing the user to select one value. I am just looking to replace this If statement in the Background Color.

=if(GetFieldSelections(PetType)=PetType,Green())

Re: Another Question about Using Pick for Formatting

trdandamudi — Wed, 29 Nov 2017 19:54:49 GMT

May be as below:

Replace: =if(GetFieldSelections(PetType)=PetType,Green())

With this : =pick(match(GetFieldSelections(PetType), PetType), Green())

Re: Another Question about Using Pick for Formatting

datagrrl — Wed, 29 Nov 2017 20:07:14 GMT

I thought I tried this. I think I was once again making this harder than it needed to be. Thanks for your help.

Re: Another Question about Using Pick for Formatting

trdandamudi — Wed, 29 Nov 2017 20:09:05 GMT

You are welcome and glad able to help.

Re: Another Question about Using Pick for Formatting

swuehl — Wed, 29 Nov 2017 20:19:58 GMT

Or maybe

If(len(PetType), Green())