Another Question about Using Pick for Formatting

[datagrrl]

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())

[trdandamudi · Accepted solution]

May be as below:

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

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

[datagrrl]

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

[trdandamudi]

You are welcome and glad able to help.

[swuehl]

Or maybe

If(len(PetType), Green())